Using Slowly Changing Dimensions - SAS Data Integration Studio 3.3 User's Guide - page 207

superseded by a new current row. When the job is run, data will be provided for
this column by the SCD Type 2 Loader.
9 In the row for VALID_TO_DTTM, specify the Numeric type and the Datetime20.
format.
10 To add the third new column, click New and replace the default column name with
the name CUSTOMER_GEN_KEY . This column will provide unique key values for all
of the rows in the table. The new key values will be generated by the SCD Type 2
Loader.
11 Press the TAB key twice, then double click and select the Numeric data type.
12 Press the TAB key once, then click and type 12. , which is a numeric format.
13 Click the row number on the far left for the row CUSTOMER_GEN_KEY and drag
the column up to position number one. The columns of the dimension table are
now configured for slowly changing dimensions, as shown in the following display.
Display 12.6 Columns in the Dimension Table
14 Click Apply to save your changes.
The next step is to designate the generated column as the primary key for the
dimension table.
Specify the Primary Key for the Dimension Table
Follow these steps to designate the generated column as the primary key for the
dimension table:
1 In the properties window for the CUSTOMER_SCD table, click the Keys tab.
Locate the New button in the left pane of the tab.