anti pivot

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
Roopanwita
Participant
Posts: 125
Joined: Mon Sep 11, 2006 4:22 am
Location: India

anti pivot

Post by Roopanwita »

Hi,
In datastage we use Pivot stage to normalize data.Is there any stage or any way in datastage to do reverse,i.e to denormalize the normalize data.
Thanks
Top
kris
Participant
Posts: 160
Joined: Tue Dec 09, 2003 2:45 pm
Location: virginia, usa

Re: anti pivot

Post by kris »

There is no stage in DataStage that does exactly unpivot.

But mostly unpivoting would be easy enough to do with SQL (sub-queries and group by) in the database.
~Kris
Top
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

As said there is no specific stage to do this but there are plenty of posts in the forum where this had been discussed. Do a search.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Search for "vertical pivot".

The Pivot stage in version 8.1 (early 2008) will support both horizontal and vertical pivoting, according to the DataStage roadmap presentation at IoD 2007.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”