The Usage of Pivot Stage in DataStage Jobs

[WoMaWil]

Hello Ranjan,

you are mixing 2 things. The pivot stage is something for pivoting. As you know excel it is about the same.

If you have a table like this:

Name Month Sum
John 04 2000
Paul 04 3000
John 05 1500
Pete 04 3400
Paul 05 6000
pete 05 5600

and you want to make a table like this:

Name SumMonth04 SumMonth05
John 2000 1500
Paul 3000 6000
Pete 3400 5600

then you should use the Pivot-Stage.

For the deployment of Jobs to an other site instead of using the import and export in manager you can also use the package installer.

Wolfgang

[ray.wurlod]

All this is particularly well explained in the manual for the Pivot stage, which is on your DataStage CD in the Packages folder.

Tip: When I install a plug-in stage, I move its manual to the Docs folder on my DataStage client machine.