DSXchange

Hi,
Is there any transformer in DataStage Server Edition, which can perform similar to Make Vector in Parallel stage.
I want to convert a row input to column in the target, but i am using Datastage Server edition.

Please help.

Welcome aboard. :D

There's no specific equivalent of the Make Vector stage, but you can do it easily with the multi-value handling capabilities of a UniVerse stage.
Create a table definition that supports multi-valued fields.
Load the dynamically normalized table then select from the un-normalized table and convert the value marks (@VM) into whatever other separator you require in your vector.