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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
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.
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.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'