Incrementally loading the fact tables

Loading the fact tables incrementally improves system performance by loading only new and changed data.

To use incremental loading, you must edit the Source Configuration Area and select incremental loading in the properties of the Business Group.

  1. In the Source Configuration Area, expand the Fact Tables node.
  2. For each ID field, set the value of the primary key to True.
  3. In the fact table, select the date field that contains the incremental time load stamp information. In the field Category, set its value to IS_INCREMENTALLOADTIMESTAMP.
  4. In the Business Groups node, right-click the business group and select Properties.
  5. Click the Loading Fact Data tab.
  6. In the Period column, select Incremental load from the drop-down list.