Selecting purpose codes in the DataStage® Slowly Changing Dimension stage

Purpose codes specify how the Slowly Changing Dimension (SCD) stage should process dimension data.

About this task

Purpose codes apply to columns on the dimension reference link and on the dimension update link. Select purpose codes according to the type of columns in a dimension:
  • If a dimension contains a Type 2 column, you must select a Current Indicator column, an Expiration Date column, or both. An Effective Date column is optional. You cannot assign Type 2 and Current Indicator to the same column.
  • If a dimension contains only Type 1 columns, no Current Indicator, Effective Date, Expiration Date, or SK Chain columns are allowed.

Procedure

  1. On the Input tab, select the reference link in the Input name field.
  2. In the Lookup section, click Edit. The Edit lookup page opens.
  3. In the Purpose column, select a purpose code for each row.