Database Reference
In-Depth Information
SCD2 (flag) - flag the history
To implement SCD2 by maintaining the flag, 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_FLAG
) of the new
SCD2 mapping. Select
Type 2 Dimension - keep a full history of the changes in
the target
, as we are implementing SCD2, and click on
Next
.