Datawarehousing

How To Load Star Schema Dimensions And Facts In Parallel

By | December 19th, 2015|Data Integration Concepts|

One of the bottlenecks often encountered in ETL development for start schema is the sequence of loading dimension tables before being able to load any fact table. Obviously, it happens since fact tables need those surrogate keys from dimension tables in any dimensional data model. I always wondered if there could be a better way [...]

Mistakes To Avoid In Bottom-Up Datawarehouse Development Approach

By | February 22nd, 2015|Data Modeling, Miscellaneous|

There is a vigorous debate going on since the advent of datawarehousing in the DW community about whether to build applications top-down or bottom up. The model often requires implementation of numerous, large, normalized, relational target databases, including a central data warehouse, Operational Data Store, Persistent Staging Area, and additional databases, such as an Exploration [...]

How to Select an ETL Tool For Datawarehousing

By | February 22nd, 2015|Data Integration Concepts|

Selection of an appropriate ETL tool is the most important decision that has to be made in choosing components of a data warehousing application. The ETL tool operates at the heart of the data warehouse, extracting data from multiple data sources, transforming the data to make it accessible to business analysts, and loading multiple target [...]