Slowly Changed Dimension Mapping |
Type |
Description |
SCD Type 1 |
Slowly Changing Dimension
|
Inserts new dimensions. Overwrites existing dimensions with changed dimensions. (Shows Current Data) |
SCD Type 2 /Version Data |
Slowly Changing Dimension |
Inserts new and changed dimensions. Creates a version number and increments the primary key to track changes. |
SCD Type 2 /Flag Current |
Slowly Changing Dimension |
Inserts new and changed dimensions. Flags the current version and increments the primary key to track changes. |
SCD Type 2 /Date Range |
Slowly Changing Dimension |
Inserts new and changed dimensions. Creates an effective date range to track changes. |
SCD Type 3 |
Slowly Changing Dimension |
Inserts new dimensions. Updates changed values in existing dimensions. Optionally uses the load date to track changes. |
