SCD2 (version number) - I need my ancestors!

To implement SCD2 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 of the new SCD mapping (m_SCD2_VERSION_NUMBER). Also, select the Type of SCD you wish to implement. Select Type 2 Dimension - keep a full history of the changes in the target as we are implementing SCD2 using version number. Click on Next:

3. The next screen will ask you to select the source. Select a source from the drop-down. 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_SCD2_VERSION_NUMBER for our reference in this book. Click on Next:

4. In the next window, select EMPLOYEE_ID as Logical Key Field. Also, add LOCATION under Fields to compare for changes. Click on Next:

5. The next screen asks you to choose the option to maintain...