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 ...

Get Microsoft® SQL Server™ 2005 Integration Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.