Sorting stage clarification

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Sorting stage clarification

Post by pandeesh »

Hi
I have 3 columns as keys in my sort stage.
But I want to sort on 3 keys but I need to create key change column based on 2 keys only. I think I can achieve this using 2 sort stages .
But Is there any way to do in a single sort stage?
My soure is sequential file

Thanks
pandeeswaran
kamtammystuff
Participant
Posts: 26
Joined: Fri Feb 19, 2010 2:08 am

Post by kamtammystuff »

Try using in-line sort with the three columns and mention only the 2 columns as sorking keys in the 'stage' tab on which you want to generage key change column.
pandeesh
Premium Member
Premium Member
Posts: 1399
Joined: Sun Oct 24, 2010 5:15 am
Location: CHENNAI, TAMIL NADU

Post by pandeesh »

Yes that's worked
pandeeswaran
kamtammystuff
Participant
Posts: 26
Joined: Fri Feb 19, 2010 2:08 am

Post by kamtammystuff »

cool... :D mark it as Resolved.
Post Reply