DSXchange

hi

i am reading data from oracle like this

empno1 sal

1 10000
1 10000
1 10000
1 12000
here 4 sal are the months of jan.,feb., mar., apr...

output like this report

empno jan feb mar apr may


so, pls help me how get this output using in datastage.
thnks
venkat

Vertical pivoting (rows to columns) can be performed in DataStage using a number of techniques. Search DSXchange for "vertical pivot".