Difference Stage Versus Change Capture Stage

rameshrr3 · Post by **rameshrr3** » Thu Jan 10, 2013 4:10 pm

I need some good reference for the comparison between Difference Stage and Change Capture stage in terms of performance & features. The only difference I could see so far was the requirement of pre sorted inputs to Difference stage ( and less important is the different integer values for the change codes ( Copy/Modify/Add/Delete ) )

ray.wurlod · Post by **ray.wurlod** » Thu Jan 10, 2013 5:35 pm

The best reference is the chapter for each stage type in the Parallel Job Developer's Guide. Put them "side by side" mentally. You'll also find the statement that one has been deprecated in favour of the other; take that statement with the proverbial grain of salt.

The big difference (for me) is the structure of the output. And don't forget that there's a Compare stage too.

rameshrr3 · Post by **rameshrr3** » Thu Jan 10, 2013 5:55 pm

Yes I remember seeing that the Difference stage was deprecated - But I have been seeing that in the docs ever since we had version 8. Im using v 8.7 now - and I can still the Difference stage ( as well as Compare stage - which by the way is giving me an error - Off to search i go

)