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.
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.
- On the Input tab, select the reference link in the Input name field.
- In the Lookup section, click Edit. The Edit lookup page opens.
- Define the match condition, then click Apply and return.