choose compare/difference/change data capture

michael_west · Post by **michael_west** » Mon Jun 25, 2007 9:12 am

How do I choose between the compare, difference, and change data capture stages. It appears to me that the change data capture stage does everything that compare and difference do so I have always used change data capture. Am I missing something? I hate it when I am missing something...

vijayrc · Post by **vijayrc** » Tue Jun 26, 2007 5:09 am

michael_west wrote:How do I choose between the compare, difference, and change data capture stages. It appears to me that the change data capture stage does everything that compare and difference do so I have always used change data capture. Am I missing something? I hate it when I am missing something...

Yes Change Capture does all the trick that Compare/Diff does. But if your need is just to do a 'DIFF' or a 'COMPARE' you may want to go with those specifics, just to make the job design more understable

Otherwise Change Capture does it all

ray.wurlod · Post by **ray.wurlod** » Tue Jun 26, 2007 5:23 am

Compare compares the entire record and can report direction of difference (> or <) rather than just "different". Difference and Change Capture perform the same comparison, but present their output in different format; Change Capture uses subrecords.

kumar_s · Post by **kumar_s** » Tue Jun 26, 2007 5:39 am

Each stage as unique functionality of its own, with respect to the links, input / output dataset. Which could be found in the documentation.
Minor difference can be found at obtaining before / after dataset as output.

Minhajuddin · Post by **Minhajuddin** » Tue Jun 26, 2007 10:59 pm

I gotta get a Premium Membership

DSXchange

choose compare/difference/change data capture

choose compare/difference/change data capture

Re: choose compare/difference/change data capture