The change Capture stage in DataStage allows to Capture the Change in two source datasets(before and after) and mark the difference in one of the output column. The comparison is made by key columns specified in properties. The changes are recorded as insert, copy, edit and delete. The incoming data is assumed pre-sorted in ascending order and key partitioned.
Let us assume following are incoming datasets
Here for employee id with 1 and 5 salaries is changed.
The Change_code Column is automatically generated and must be mapped in the output tab of Change capture stage.