Databases Reference
In-Depth Information
3 In the End Date row, in the Column Name column, double-click to display the
pull-down menu. Then select the end date column in the dimension table
(VALID_TO_DTTM). The Change Tracking tab will look similar to the following
display.
Display 12.10 Change Tracking Tab
4 Click Apply to save your changes.
The last configuration step is to set up change detection.
Set Up Change Detection in the SCD Loader
Follow these steps to configure change detection in the SCD loader:
1 In the properties window for the SCD Type 2 Loader, click the Detect Changes
tab.
2 Press and hold the CTRL key, then click the columns for which you will detect
changes. In this example, select LAST_NAME, JOB_ID, ZIP_CODE,
PHONE_NUMBER, CREDIT_LIMIT, ANNUAL_INCOME, and
HOUSE_HOLD_ID.
 
Search WWH ::




Custom Search