DSXchange

I am new datastage can anyone guide me where to write deravations in the pivot stage and what kind of derivation can be wrriten

Please advice

The derivations would just list the column names to be pivoted and all this should be documented in the online help available from the 'Help' button inside the stage or the pdf documentation installed on your PC.

The input link Columns page contains three input columns with sales data:
JAN_Sales, FEB_Sales, and MARCH_Sales. The columns are as follows:
The data for the source rows for the input columns looks like this:
Input Source Rows
CUSTID LNAME JAN_Sales FEB_Sales MARCH_Sales
100 Smith $1,234.00 $1,456.00 $1,578.00
101 Yamada $1,245.00 $1,765.00 $1,934.00




The three output rows of sales data that result from each input row in this example
are as follows:
Output Target Rows
CUSTID Last_Name Sales
100 Smith $1,234.00
100 Smith $1,456.00
100 Smith $1,578.00
101 Yamada $1,245.00
101 Yamada $1,765.00
101 Yamada $1.934.00


Derivation for output column Sales will be (JAN_Sales,FEB_Sales,MARCh_Sales).

In other words, pretty much the same thing you'd see in the documentation. Minus any discussion of key fields.