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?
Sorting in Change Capture stage.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
-
- Participant
- Posts: 57
- Joined: Wed Oct 21, 2009 4:46 am
- Location: India
-
- Participant
- Posts: 58
- Joined: Tue Nov 17, 2009 3:38 am
Thanks Rohit.rohithmuthyala wrote: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.
But in that case what will the ""Sort Order" option do in change capture stage?
Nikhil
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
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.rohithmuthyala wrote: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.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.