SCD2 (flag) - flag the history

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:

• A new window will pop up asking the name (m_SCD2_FLAG) of the new SCD2 mapping. Select Type 2 Dimension - keep a full history of the changes as we are implementing SCD2, and click on Next:

• 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_FLAG for our reference in this book. Click on Next:

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

• The next screen asks you to choose the option to maintain the history in the target. Select Mark the 'current' dimension record with a flag, and click on Finish...