Sorting in Change capture

[ady]

Hi,

Do I have to sort the fields mentioned as keys in the same order as they are in change capture stage?


ie: If i mention the the columns a,b,c,d as keys, do i have top do the sort in the same order (a,b,c,d) ?

Do I have to perform a sort on the fields mentioned as values also?

[us1aslam1us]

I would say do that and also be careful with your Partioning method.

[ady]

I'm using hash ..... is there a better option ?

[kumar_s]

Yes, Hash partition on the keys fields before sort and maintaing the SAME partition to the CC stage will out expected result.