DSXchange

Thanks all for your suggestions.

We have a table which has 28 columns, in addition to the key columns. I need to convert every such row to 28 rows. I have about 5 million rows in the input. We have written a BuildOp stage as per the suggestions but that doesn't seem to make much of a difference.

Can you please elaborate on how we can do this ?

I have about 5 million rows coming in the input. Each row has 28 columns, in addition to the key columns. I need to generate 28 rows from each input row. So the number of rows in output which will be fed to a teradata enterprise stage are 5*28 million rows. I am using the PIVOT stage to achieve this...