Data Warehouse

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

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

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

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…