Please explain the difference between COMPARE and CHANGE CAPTURE STAGE in datastage.?
Under what circumstances which one to be used ? Please explain
[* Title changed to be more descriptive - Andy *]
What is difference between COMPARE and CHANGE CAPTURE STAGE
Moderators: chulett, rschirm, roy
-
Ankur_KapoorUK
- Participant
- Posts: 64
- Joined: Fri Feb 05, 2010 5:29 am
- Location: India, UK
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The essential difference is based on the eventual use to which they are to be put. The Change Capture stage generates a structure that can be used by a subsequent Change Apply stage to reconstruct the After input from the Before input.
A Compare stage yields not just the fact that there is a difference by also the direction of that difference - that is, greater than or less than as applicable - when treating the source record (comparison fields) as a single string.
You should probably also research the Difference stage.
A Compare stage yields not just the fact that there is a difference by also the direction of that difference - that is, greater than or less than as applicable - when treating the source record (comparison fields) as a single string.
You should probably also research the Difference stage.
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.