DSXchange

The requirement is to capture changes at sequential file level (about 50 columns). Any column may have changes. Is there a way to capture the changes (insert, delete, update indicator) without specifying all 50 columns as keys in Change Capture stage?

I don't think so. You have to specify those columns.

Thanks

reachsam11 wrote:The requirement is to capture changes at sequential file level (about 50 columns). Any column may have changes. Is there a way to capture the changes (insert, delete, update indicator) without specifying all 50 columns as keys in Change Capture stage?

You need a set of keys, which will uniquely identify a row and then the stage will compare all the values of the other fields inside a Change capture stage as far as I know. You might want to consider using the "Difference" stage.

We solved this problem in 7.5.2 by writing a build op that did the comparisons. Our requirement was given a set of data in the format of
produce a row of data for each column changed based on keys. The produced row was of the format
We send it a sorted data set and it produces the rows we need.

Thanks for the repsonses..I will try them out..

Try the unix diff command or its variations.

Set the Change Mode property to Explicit Keys, All Values

Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you need)

Thanks, this works!!!

ray.wurlod wrote:Set the Change Mode property to Explicit Keys, All Values

Use a Difference stage with All non-Key Columns are Values or a Compare stage (depending precisely on the form of output you ...