Example 1: all output results
This example of the changecapture operator assumes that the input data set records contain customer, month, and balance fields
. The operation examines the customer and month fields of each input record for differences. By default, InfoSphere® DataStage® inserts partition and sort components to meet the partitioning and sorting needs of the changecapture operator and other operators.
Here is the osh command:
$osh "changecapture -key month -key customer
-value balance
< before_capture.v < after.v > change.ds"