SCD2 (flag) - flag the history
To implement SCD2 by maintaining a flag, follow these steps:
- In the
Designer, go toTools|Mapping Designer|Mapping|Wizard|Slowly Changing Dimensionsas shown in the following screenshot:
- A new window will pop up asking the name (
m_SCD2_FLAG) of the new SCD2 mapping. SelectType 2 Dimension - keep a full history of the changesas we are implementing SCD2, and click onNext:
- The next screen will ask you to select the source. Select a source from the drop-down. We are using
EMP_FILE.txtas the source file for our reference. Also, specify the name of the target you wish to create. We will name the targetEMPLOYEE_SCD2_FLAGfor our reference in this book. Click onNext:
- In the next window, select
EMPLOYEE_IDasLogical Key Field. Also, addLOCATIONunderFields to compare for changes,and click onNext:
- 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 onFinish...
