Database Reference
In-Depth Information
SCD1 - I hate history!
To implement SCD1 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_SCD1
) of the new SCD map-
ping. Select
Type 1 Dimension - keep most recent values in the target
, as we are
implementing SCD1. Click on
Next
as follows: