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.