DSXchange

I have a job which does compare two input files and produces output reports. My design is inputfile1 and inputfile2 feed into a difference/cdc stage and based on the diff/change code, I route the records to respective report.

This is working fine for us. I want to make this more generic so that I can use the same job for any file with any metadata. Can this be done using RCP?


Thanks in advance.
Anu

Split from this 7 year old semi-related post. Please just start your own topic next time for things like this.

Yes, but only if your comparison basis is "all fields are key"

Thanks Ray.

I have tried that and in that case for example
One out of 100 columns is not matching that
Row will end up in mismatch report

So validatiob team need to spend lot tine
again To verify which out o 100 columns is not matching

You can't have both.
If you want DataStage to compare specific columns, you have to name those columns (at least) and that, in turn, limits or rules out the use of RCP.

Thank you Ray. I am thinking to have a generic datastage job to compare row to row and then another program ( may be a UNIX script) to further compare at column level.

-Thanks