Create keychange column vs create cluster keychange column
Moderators: chulett, rschirm, roy
Create keychange column vs create cluster keychange column
Can anyone explain the difference between the options Create keychange column and create cluster keychange column in sort stage?
thanks
thanks
pandeeswaran
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
@chulett
I have checked in the pdf and was surprised to see that both defination are almost the same.
Create cluster key change column
This property appears for sort type DataStage and is optional. It is set False by default. If set True it tells the Sort stage to create the column clusterKeyChange in each output record. The clusterKeyChange column is set to 1 for the first record in each group where groups are defined by using a Sort Key Mode of Don't Sort (Previously Sorted) or Don't Sort (Previously Grouped). Subsequent records in the group have the clusterKeyChange column set to 0.
Create key change column
This property appears for sort type DataStage and is optional. It is set False by default. If set True it tells the Sort stage to create the column KeyChange in each output record. The KeyChange column is set to 1 for the first record in each group where the value of the sort key changes. Subsequent records in the group have the KeyChange column set to 0.
I have checked in the pdf and was surprised to see that both defination are almost the same.
Create cluster key change column
This property appears for sort type DataStage and is optional. It is set False by default. If set True it tells the Sort stage to create the column clusterKeyChange in each output record. The clusterKeyChange column is set to 1 for the first record in each group where groups are defined by using a Sort Key Mode of Don't Sort (Previously Sorted) or Don't Sort (Previously Grouped). Subsequent records in the group have the clusterKeyChange column set to 0.
Create key change column
This property appears for sort type DataStage and is optional. It is set False by default. If set True it tells the Sort stage to create the column KeyChange in each output record. The KeyChange column is set to 1 for the first record in each group where the value of the sort key changes. Subsequent records in the group have the KeyChange column set to 0.
Thanx and Regards,
ETL User
ETL User
I've highlighted what seems to me to be the key difference in what chandra posted. One option is for use when the data is already sorted, the other when the stage does the sorting. Not sure why they felt a need to have two separate options but obviously they did.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India