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