Checksum stage in DataStage

Use the Checksum stage to generate a checksum value from the specified columns in a row and add the checksum to the row.

You can use the checksum value to check the validity of each row when it is written to the data target. If the checksum value does not equate to the columns from which it was generated, then the data is corrupt and is no longer valid.

Typically you create the Checksum stage in one job to add the checksum column, and then use a Checksum stage in another job to check the validity of the data.