Database Reference
In-Depth Information
SCD3 - store something, if not everything!
To implement SCD3 using wizard, perform the following steps:
1. In the designer, navigate to
Tools
|
Mapping Designer
|
Mapping
|
Wizard
|
Slowly Changing Dimensions
, as shown in the following screenshot:
2. A new window will pop up, asking you the name (
m_SCD3
) of the new SCD map-
ping. Also, select the type of SCD you wish to implement. Select
Type 3 Dimen-
sion - keep the current and previous value in the target
, as we are implementing
SCD3, and click on
Next
.