Category: Technical Resources

Data Warehouse
Posted inFAQsTechnical Blogs . . .

An Overview of Logical Data Warehousing

Popularized by Gartner IT analyst Mark Beyer in 2011, the term “logical data warehousing” is defined as an architectural layer that combines the strength of a physical data warehouse with…

Data Warehouse
Posted inTechnical ResourcesTechnical Blogs

What is Data Virtualization?

At its core, data virtualization falls within the domain of data integration. But unlike traditional data integration where Extract-Transform-Load (ETL) processes are used to physically move copies of data from…

Data warehouse
Posted inTechnical ResourcesTechnical Blogs

The Role of ETL in a Data Warehouse Architecture

Integrating, reorganizing, and consolidating large amounts of data from a variety of different sources is a key consideration when planning your data warehouse architecture. Extract-Transform-Load (ETL) processes are used to…

Data Warehouse
Posted inTechnical BlogsTechnical Resources . . .

Tracking Historical Data in Your Data Warehouse Using Slowly Changing Dimensions

When building business intelligence applications using the enterprise data warehouse or production databases as the source, attribute changes need to be handled with considerable care. The way you model your…

Data Warehouse
Posted inTechnical ResourcesFAQs . . .

A Guide to Data Modeling and its Different Phases

Data modeling refers to the exploration of data-oriented structures. It is a process that involves documenting a complex software design in a comprehensive diagram, using symbols and texts, to represent…