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"