Defining the match condition in the DataStage® Slowly Changing Dimension stage

The match condition specifies how the Slowly Changing Dimension (SCD) stage performs the dimension lookup.

About this task

You must associate at least one pair of columns, but you can define multiple pairs if required. When you define more than one pair, the SCD stage combines the match conditions. A successful lookup requires all associated pairs of columns to match.

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. Define the match condition, then click Apply and return.