SCD3 - store something if not everything

To implement SCD3 using wizard, please follow the steps mentioned here:

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_SCD3) of the new SCD mapping. Also select the type of SCD you wish to implement. Select Type 3 Dimension - keep the current and previous value in the target as we are implementing SCD3, 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. We will name the target EMPLOYEE_SCD3 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. In the next window, select the target columns you wish to compare to detect changes. In our case, the LOCATION column in the target will be...