DSXchange

HI
I have Requirement like this

Input
PID JOBNAME
1 A
1 B
1 C
.
.
. X


My output should be

PID JOBNAME
1 A,B,C.,.,.X

Could you please help me in acheiving in datastage

Thanks in Advance
Mohammed Tausif

That would be a 'vertical pivot' (aka rows to columns) and an exact search here will reveal the options you have.

If it is verticle pivot for rows in to column we can acheive it in transformer,but here the rows should be concatenated in to single column.

Still a vertical pivot and to me the easiest way to solve the 'concatenation' part in a Server job is to use a Hashed File. Read and write to it in the same transformer, create a new record for each key on a lookup miss and append values on a lookup hit. Make sure you do not cache the lookup.

A search here would have revealed this.

Or just do the appending in a Transformer stage. Follow the Transformer stage with an Aggregator stage that captures the last row of each group.

Or that... another technique the search would have turned up.

One approach requires sorted data, the other does not.