What is the use of pivot stage?

[SHARAD123]

Pivot stage is used in what conditions?
Could someone help me out!!!!

[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.

[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

Code: Select all

Department, Year, Month, Sales

In this example the output would contain 12 rows for every input row.

[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.