Sorting in Change Capture stage.
Posted: Sun Apr 11, 2010 10:55 pm
Hi,
As per the DS Manual "The change Capture stage assumes the data to be sorted and hash partitoned".
But,in the "Properties tab" of Change Capture stage,the "Sort Order" option is also present.
Does it mean that change capture stage will by default sort the data on the key column?When this option is already there,is there any need of sorting the data before it reaches the Change Captuer stage?
As per the DS Manual "The change Capture stage assumes the data to be sorted and hash partitoned".
But,in the "Properties tab" of Change Capture stage,the "Sort Order" option is also present.
Does it mean that change capture stage will by default sort the data on the key column?When this option is already there,is there any need of sorting the data before it reaches the Change Captuer stage?