Databases Reference
In-Depth Information
2 Click the down arrow to the right of the New button and select Primary Key from
the pull-down menu. Default metadata for a primary key appears.
3 In the right pane of the tab, select the CUSTOMER_GEN_KEY column, then click
the right arrow. The CUSTOMER_GEN_KEY column is now specified as the
primary key of the dimension table, as shown in the following display.
Display 12.7
Primary Key for the Dimension Table
4 Click OK to save your changes and close the properties window for the dimension
table.
You have now configured the metadata for the dimension table. The next step is to
configure keys and change tracking for the SCD loader.
Specify the Business Key for the SCD Loader
The business key is the primary key of a source table that is used to load the
dimension table. In this example, the business key would be the CUSTOMER_ID
column in the CUSTOMER_TRANS table. Follow these steps to specify the business
key for the SCD loader:
1 In the Process Designer window, double-click the icon for the SCD Type 2 Loader
to display its properties window.
2 In the properties window, click the Business Key tab. Click New to display the
column selection window.
 
Search WWH ::




Custom Search