Databases Reference
In-Depth Information
2 Click the down arrow to the right of the Column field and select the generated
column that you specified earlier for the dimension table
(CUSTOMER_GEN_KEY). Assume that the default values shown in the following
display are correct, and no further updates are needed on this tab.
Display 12.9 Generated Key for the SCD Loader
For more information about using this tab, click Help .
3 Click Apply to save your changes.
The next step is to set up change tracking.
Set Up Change Tracking in the SCD Loader
Follow these steps to configure the automatic insertion of date and time information
in the dimension table:
1 In the properties window for the SCD Type 2 Loader, click the Change Tracking
tab.
2 In the Beginning Date row, in the Column Name column, double-click to display
the pull-down menu. Then select the beginning date column in the dimension
table (VALID_FROM_DTTM).
 
Search WWH ::




Custom Search