Generic file compare using RCP

anu123 · Post by **anu123** » Wed Feb 27, 2013 3:34 pm

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

chulett · Post by **chulett** » Wed Feb 27, 2013 3:40 pm

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

ray.wurlod · Post by **ray.wurlod** » Wed Feb 27, 2013 7:42 pm

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

anu123 · Post by **anu123** » Fri Mar 01, 2013 9:41 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Mar 01, 2013 2:44 pm

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.

anu123 · Post by **anu123** » Tue Mar 05, 2013 12:45 pm

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