Change Capture stage: fast path (DataStage)

This section specifies the minimum steps to take to get a Change Capture stage functioning.

1. Go to the Properties section on the Stage tab.
2. 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.
3. 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.
4. 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).
5. 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.
6. 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.
7. 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.