1. Data Catalog
  2. Data Catalog Components
  3. Slowly Changing Dimensions
  4. Types of SCDs

4.6.1 Types of SCDs

The type of SCD Catalog supports is:

  • Type 2 SCDs - Creating another dimension record: A Type 2 SCD retains the full history of values. When the value of a chosen attribute changes, the current record is closed. A new record is created with the changed data values and this new record becomes the current record. Each record contains the effective time and expiration time to identify the time period between which the record was active.

The Dimension Population Process in the Process Orchestration displays the available SCDs with details such as Map Reference Number and Entity Name.