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

9 In the Project tree, click and drag CUSTOMER_SCD into the target drop area of the
SCD Type 2 Loader transformation. The job is now fully populated with tables and
transformations, as shown in the following display.

Display 12.5 Fully Populated Job for Loading the Dimension Table CUSTOMER_SCD

The next step is to add tracking columns and a generated key column to the
CUSTOMER_SCD table.

Add SCD Columns to the Dimension Table
Follow these steps to add tracking columns and a generated key column to the
CUSTOMER_SCD table:
1 In the Process Designer window, double-click the icon for the CUSTOMER_SCD
table to display its properties window.
2 In the properties window, click the Columns tab. Initially, the CUSTOMER_SCD
dimension table was created with the same columns as the source table
CUSTOMER_TRANS. (These columns are shown in Display 12.4 on page 204.) To
implement slowly changing dimensions, the dimension table needs three new
columns.
3 To add the first new column, click CUSTOMER_ID , then click New . A new untitled
column appears beneath CUSTOMER_ID.
4 Replace the default name of the new column with the name VALID_FROM_DTTM .
This column will contain the date and time that each row was physically loaded
into the table. When the job is run, data will be provided for this column by the
SCD Type 2 Loader.
5 In the row for VALID_FROM_DTTM , double-click the Type column and select Numeric .
6 In the row for VALID_FROM_DTTM , double-click the Format column and type
Datetime20. .
7 In the row for VALID_FROM_DTTM , click New . A new untitled column appears
beneath VALID_FROM_DTTM .
8 Replace the default name of the second new column with the name
VALID_TO_DTTM . This column will contain the date and time that each row was