Transform multiple columns into multiple records

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Hi Gabriel,

it is easy to manage, it depends if n is fix or variable. If it is fix you take for every colum from table1 a link to you table2, so each link writes a row.

If it is variable you have to use the multivalue function of a hash file.

So much success for you.


Wolfgang Huerter
=====================
Cologne, Germany
Top
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
another way is to use a pivot stage.


Roy R.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”