Page 1 of 1
What is the use of pivot stage?
Posted: Thu Jan 10, 2008 12:30 am
by SHARAD123
Pivot stage is used in what conditions?
Could someone help me out!!!!
Posted: Thu Jan 10, 2008 12:32 am
by chulett
When you need to 'pivot' columns out into multiple rows. You can help you out - read the online help available from the 'Help' button inside the stage for specifics.
Posted: Thu Jan 10, 2008 12:43 am
by rleishman
To convert 1 input row into 2 or more output rows. For example, you could pivot a row that contained:
Code: Select all
Department, Year, Sales_Jan, Sales_Feb, Sales_Mar, ...
into
In this example the output would contain 12 rows for every input row.
Posted: Thu Jan 10, 2008 12:45 am
by sachin1
Pivot is an active stage that maps sets of columns in an input table to a single
column in an output table.
hope you have a pdf named "pivot.pdf" deployed with your Datastage software, that can help you know more.