Managing Fact Tables
You’ve learned that when maintaining data for fact tables and dimension tables, the order is important because you don’t want to load fact data that has dimension relationships (foreign to primary key) that might not already exist in the dimension tables. So the order (or control flow) of your data warehouse SSIS packages is important. As a rule, dimension data processing should be performed before fact table data.
Aggregating Data in Fact Tables
Data is generally aggregated to store the summarized information over a period of time of the fact measures such as the number of units of a product sold in a given month. The source for these aggregations is the detailed granular fact, which collects transactional information from ...