5.2. Fact Table ETL

Processing fact records from the source system into the destination fact table involves some common ETL processes, which map to the fact table column types. Fact table ETL involves the following:

  • Acquiring the dimension surrogate keys

  • Calculating measures

  • Identifying existing records for changes

  • Managing changes in the data grain

This discussion of fact table ETL considers such aspects, applied with SSIS.

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.

Start your free trial