Hello guys
Can anybody please clarify ,what is the difference between 'Create cluster Key Change Column' and 'Create Key Change Column' option in Sort Stage ?
From reading the doc,both the options looks similar.
Thanks in advance for your help
Regards
Ulhas
Sort Stage Query
Moderators: chulett, rschirm, roy
-
sacheens23
- Premium Member
- Posts: 5
- Joined: Wed Jul 13, 2011 11:45 pm
Re: difference between CCKCC and CKCC
How do we know if the data are "previously grouped"? "Previously Sorted" is easy to understand. I have a job contains JOIN stage followed by Sort stage. Data are sorted using link sort before the JOIN stage. Can I use "Previously Goruped" option? Why cannot use "Previously Sorted" option? Thanks in advance.
Regards
Jie
Jie
-
prakashdasika
- Premium Member
- Posts: 72
- Joined: Mon Jul 06, 2009 9:34 pm
- Location: Sydney
If you only partition on a key and do not sort, it is 'grouped'. If you do partition and sort on the key then it is 'sorted'.
If the sort keys in the sort stage are same as the sort keys in join stage then you need to use - Create Cluster Key Change Column (Don't sort previously sorted) , If the keys are different, define the new keys and use - Create Key Change Column.
If the sort keys in the sort stage are same as the sort keys in join stage then you need to use - Create Cluster Key Change Column (Don't sort previously sorted) , If the keys are different, define the new keys and use - Create Key Change Column.
Prakash Dasika
ETL Consultant
Sydney
Australia
ETL Consultant
Sydney
Australia
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: