choose compare/difference/change data capture
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 7
- Joined: Mon Jul 25, 2005 8:40 am
choose compare/difference/change data capture
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...
Re: choose compare/difference/change data capture
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 allmichael_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...
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
Minor difference can be found at obtaining before / after dataset as output.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
I gotta get a Premium Membership
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>