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

4.6 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 selected the Retire SCD, you can load incremental or snapshot data for master tables and execute SCD process with additional parameters. The incremental data load for master tables is supported.
Current behavior of Diasbled Nodes:
  • Disable a node only if you are sure that all the transactions for that node have been processed in AFCS. Once the nodes are disabled, it cannot be enabled.
  • 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.