SCD2 (date range) - marking the dates

To implement SCD2 by maintaining a flag, 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_SCD2_DATE_RANGE) of the new SCD mapping. Select Type 2 Dimension - keep a full history of the changesas we are implementing SCD2, and 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_DATE_RANGE 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, and click on Next:

5. The next screen asks you to choose the option to maintain history in target. Select Mark the dimension records with their effective date range...