1. Data Catalog
  2. Accessing Data Catalog
  3. Catalog Components
  4. Slowly Changing Dimensions

2.4.8 Slowly Changing Dimensions

A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a Data Warehouse.

Note:

If you have entered the Full Load parameter as YES, you can load snapshot data for master tables and execute SCD process with additional parameters.

In case, when you have entered the Full Load parameter as YES and if the load is incremental and does not contain all the nodes, those nodes are retired by default.

When entered as NO, you can load incremental data for master tables and execute SCD process with additional parameters. The incremental data load for master tables is supported.

The retired dimensions can be brought back as part of subsequent SCD load by updating the Closed Flag column to null or N.

Current behavior of Disabled Nodes:
  • The Closed Flag attribute is not supported for the Product Processor (PP) accounts.
  • A new node in the Stage Master table with Closed Flag Y is supported and will be ignored during SCD load.