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