Sorting in Change Capture stage.

[nikhilanshuman]

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?

[rohithmuthyala]

Change capture stage will not sort the data by default on key column. One needs to sort the data and hash partition the data on key column(s) explicitly in sort stage or in the same stage.

[nikhilanshuman]

Change capture stage will not sort the data by default on key column. One needs to sort the data and hash partition the data on key column(s) explicitly in sort stage or in the same stage.

Thanks Rohit.
But in that case what will the ""Sort Order" option do in change capture stage?

[priyadarshikunal]

Change capture stage will not sort the data by default on key column. One needs to sort the data and hash partition the data on key column(s) explicitly in sort stage or in the same stage.

It will sort and hash partition data if values in environment variables for auto sort insertion and part insertion are set. and partition is set to auto.