Starting off in the early 90s for data warehousing, large companies that ran substantial transactions and had huge user base used Extract-Transform-Load (ETL) processes to consolidate transactional data across all…
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 Cleansing - Eliminate Bad Data in Your Data Warehouse
[…] with the help of emerging data warehousing techniques like data warehouse automation ...
[…] data virtualization, the data rests at one place and is not moved or replicated to an...
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…
[…] you decide whether you should implement referential integrity in your data warehouse ...
[…] the ubiquity of Extract-Transform-Load (ETL) processes for data integration, ETL tool...
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…
[…] Slowly changing dimension techniques […]...
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…
[…] develop a test strategy, you need to understand data modeling, and map data from sour...
[…] to change or extend data models to reshape them as business requirements change, givi...