DSXchange

I need to compare two files based on 2 sets of keys in a CDC stage . For instance

ID & S_No is the first combination
ID & V_No is the second combination

Is it possible to do that in the same run or do I have to run it twice with different key combinations.

TIA

compare as in?

you can do a lookup on the second file with first file as base. not sure though if thats what you want.

You can do it in the same run, but would need to split your source data into two streams and use two Change Data Capture stages, one for each.

How you combine the results is up to you, and will be driven by your business requirements, about which we have no information.