Expert SQL Server 2005 Integration Services (Programmer to Programmer)

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.