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
The Usage of Pivot Stage in DataStage Jobs
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: