Hello All
I am new to datastage though following this forum for some time now. I have a simple question on Sort stage. Appreciate if someone answer with a simple example. Only example will be enough to show the difference. I have gone through the forum history but bit confused with all answer.
"What is the differerence between the Cluster key change and key change option?"
Thanks
Sort option
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 14
- Joined: Wed Feb 01, 2012 5:26 am
- Location: Hyd
Cluster key change column
Hi ,
According to my understanding :
For Cluster key column-- sort stage itself creats the clusterkeychange in output column , and takes the default 'tinyint ' datatype. The 'sort key mode' should be in either 'Don't Sort(previously sorted/Previously grouped mode'. Cluster key mode is not ready to take the sort option.
Both the Cluster key , Key column change gives the same output as below.
In Key column change it will sort the data in specified mode and it will create the keycolumn change column in output.
For your input ,
Col1 Col2
10 Delhi
10 Mumbai
30 Adelade
40 NewYork
50 Sydney
50 LA
50 HK
Expected output :
Col1 Col2 Clusterkey
10 Delhi 1
10 Mumbai 0
30 Adelade 1
40 NewYork 1
50 Sydney 1
50 LA 0
50 HK 0
Regards
Satwika
According to my understanding :
For Cluster key column-- sort stage itself creats the clusterkeychange in output column , and takes the default 'tinyint ' datatype. The 'sort key mode' should be in either 'Don't Sort(previously sorted/Previously grouped mode'. Cluster key mode is not ready to take the sort option.
Both the Cluster key , Key column change gives the same output as below.
In Key column change it will sort the data in specified mode and it will create the keycolumn change column in output.
For your input ,
Col1 Col2
10 Delhi
10 Mumbai
30 Adelade
40 NewYork
50 Sydney
50 LA
50 HK
Expected output :
Col1 Col2 Clusterkey
10 Delhi 1
10 Mumbai 0
30 Adelade 1
40 NewYork 1
50 Sydney 1
50 LA 0
50 HK 0
Regards
Satwika
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 14
- Joined: Wed Feb 01, 2012 5:26 am
- Location: Hyd