DSXchange

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

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.