Chapter 5. Fact Table ETL
When processing data warehouses, dimension table ETL is only half the story. The next major aspect of ETL involves fact tables. But the good news is that dimension ETL usually represents the majority of the complexity in the overall warehouse ETL. To be sure, a data warehouse involves more than just dimension and fact ETL (such as data lineage, auditing, and execution precedence), but in terms of business data, dimension, and facts, it contains the core information.
In this chapter, we focus on applying SSIS to fact table ETL. We discuss the theory and general concepts of fact table ETL, including data mapping, workflow, and precedence. We also identify dimension surrogate keys and measure calculations, and discuss how to manage data grain changes.
Get Expert SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
