Database Reference
In-Depth Information
SCD2 (date range) - marking the dates
To implement SCD2 by maintaining flags, perform the following steps:
1. In the designer, navigate to
Tools
|
Mapping Designer
|
Mapping
|
Wizard
|
Slowly Changing Dimensions
, as shown in the following screenshot:
A new window will pop up, asking you the name (
m_SCD2_DATE_RANGE
) of the
new SCD mapping. Select
Type 2 Dimension - keep a full history of the changes
in the target
, as we are implementing SCD2, and click on
Next
.