ClusterKeyChange

Das · Post by **Das** » Mon Mar 10, 2008 7:38 am

I have a dobt why we need to go for ClusterKeyChange ,Does it possible by KeyChange .I have used key change in meny occations .Any body can explain the senariao in which we are going for ClusterKeyChange .and Whts the difference

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Mon Mar 10, 2008 3:57 pm

In a phrase, unsorted though grouped data.

Das · Post by **Das** » Thu Mar 13, 2008 1:45 am

ray.wurlod wrote:In a phrase, unsorted though grouped data. ...

The same, can we achieve with out clusterkeychange ?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2008 2:23 am

Yes, tediously, through Transformer stage stage variables.

Why not specify "Don't sort, previously grouped" in the Sort stage - you can still generate the cluster key change column, at virtually no cost - what you would need to do in a Transformer stage is built-in to the Sort stage.

Das · Post by **Das** » Thu Mar 13, 2008 3:48 am

ray.wurlod wrote:Yes, tediously, through Transformer stage stage variables.

Why not specify "Don't sort, previously grouped" in the Sort stage - you can still generate the cluster key change column, at virtually no ...

Thanks Ray..
Plase help me in the below senario.

Job Design
src-------------->sort1----------->sort2---------------->tgt

Properties of each stage
src : Sorce having 4 columns A,B,C,D
Sort1:

Sort Key1=A
Sort order=ASC

Sort Key1=B
Sort order=ASC

Cluster Key cahnge=TRUE

Sort2:

Sort Key1=A
( Don't sort, previously grouped )

Sort Key1=B
Sort order=ASC
( Don't sort, previously grouped )

Sort Key3=C
Sort Order=DEC
Key cahnge=TRUE

This is my current settings in the job
If Ihave chnaged the " Cluster Key cahnge " =FALSE,in Sort1 My out was same.
Why it is happening...plase suggest in wht exat scenariao we r going for cluster key change.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 13, 2008 4:43 am

Where's the grouping occurring? You're probably looking for a sort key change, not a cluster key change.