This section specifies the minimum steps to take to get a Change Capture stage
functioning.
- Go to the Properties section on the Stage
tab.
- Specify the key column. You can repeat this property to specify a composite key.
Before and after rows are considered to be the same if they have the same value in the
key column or columns.
- Optionally specify one or more Value columns. This enables you to determine if an
after row is an edited version of a before row.
Note: You can also set the Change Mode property to have IBM® DataStage® treat
all columns not defined as keys treated as values, or all columns not defined as values treated as
keys.
- Specify whether the stage will output the changed row or drop it. You can specify this
individually for each type of change (copy, delete, edit, or insert).
- In the link ordering section on the Stage tab, specify which of
the two links carries the before data set and which carries the after data
set.
- If the two incoming data sets aren't already key partitioned on the key columns and
sorted, set IBM DataStage to do
this on the Input tab.
- In the Output tab, click Edit in the Columns section, and
modify the Maps from input column section to specify how the change data
columns are mapped onto the output link columns.