SCD1 - I hate history!

To implement SCD1 using wizard, follow these steps:

1. In the Designer, go to Tools | Mapping Designer | Mapping | Wizard | Slowly Changing Dimensions as shown in the following screenshot:
   

2. A new window will pop up asking the name (m_SCD1) of the new SCD mapping. Select Type 1 Dimension - Keep most recent values in the target as we are implementing SCD1. Click on Next:

3. The next screen will ask you to select the source. Select a source from the drop-down. All the sources present in your repository will be listed in this drop-down list. We are using EMP_FILE.txt as the source file for our reference. Also, specify the name of the target you wish to create. We will name the target EMPLOYEE_SCD1 for our reference in this book. Click on Next:

4. In the next window, select EMPLOYEE_ID as Logical Key Field. This specifies which column will be used to check the existence of data in the target. Make sure the column you use is the key column of the source.

• • Also, add LOCATION under Fields...