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.
Make Vector
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.