4.3 Dimension Table Population

The Dimension Table Population Process serves two purposes:

  • Move the Flattened Hierarchy Data from Operational tables to the BI tables.
  • Execute the SCD Process against each processed dimension.

Dimension Table Population should be run after the initial creation of a hierarchy and after any changes are made to a hierarchy Dimensional data changes are handled in the ALMBI Solution using the SCD component.