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
anti pivot
Moderators: chulett, rschirm, roy
Re: anti pivot
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.
But mostly unpivoting would be easy enough to do with SQL (sub-queries and group by) in the database.
~Kris
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.