Comparing files

muascdev · Post by **muascdev** » Tue Mar 13, 2007 1:59 pm

i have a need to compare 2 files and 2 specific columns in it.. i have a need to know what column got changed. is there anyway to find out what column got changed. i dont see anywhere in change captur /compare/difference stages that tells us.

us1aslam1us · Post by **us1aslam1us** » Tue Mar 13, 2007 3:17 pm

I think you can do that with either of them. Just read only two specific columns and do a compare. I haven't tried it but give it a shot.

kumar_s · Post by **kumar_s** » Tue Mar 13, 2007 4:37 pm

If Change Capture /Compare/Difference is all about that, not sure why can you find out. If you going to compare two files, obviously there would (should) be a command key. So use Explcit Keys and Explicit values option in Change Capture stage.

muascdev · Post by **muascdev** » Wed Mar 14, 2007 8:16 am

my understanding is that all these stages will tell us if keys or values changed. if i want to know what coulmns got changed with in value columns, i didnt find any option.

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 8:19 am

Make the columns you want to compare, as keys. Apply all rules of keys to these columns, like partitioning on it, sorting etc.

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 4:58 pm

Or join the two files using Join (perhaps a full outer join), user Transformer stage, compare the column one to one. Add a Flag column for each column that you need to check and mark the value according to the change, either Yes or No.