srilakshmi

• Oct 3rd, 2006

 

 Pivot stage is used to make the horizontal rows into vertical and viceversa

laxman

• Oct 24th, 2006

 

First of all thanks to srilaxmi for your skill in pivot stage.

Pivot stage supports only horizontal pivoting ? columns into rows

Pivot stage doesn?t supports vertical pivoting ? rows into columns

Example: In the below source table there are two cols about quarterly sales of a product but biz req. as target should contain single col. to represent quarter sales, we can achieve this problem using pivot stage, i.e. horizontal pivoting.

Source Table

ProdID	Q1_Sales	Q2_Sales
1010	123450	234550

Target Table

ProdID	Quarter_Sales	Quarter
1010	123450	Q1
1010	234550	Q2