Combination of Key Attributes

vick · Post by **vick** » Mon Mar 19, 2007 9:47 am

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

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Mar 19, 2007 12:12 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 19, 2007 7:10 pm

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.