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
ClusterKeyChange
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks Ray..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 ...
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: