Split one row to multiple rows

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

ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Only UniVerse (and Hashed Files) and UniData support dynamic normalization. But, in this design, you can do normalization while selecting from the UniVerse table.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
venkatesan
Premium Member
Premium Member
Posts: 10
Joined: Sat Dec 25, 2010 11:35 pm
Location: Bangalore
Contact:

Post by venkatesan »

Hi Ray,

I tried this design also but i am not getting desired output.

Universe table --> Transformer --> Hash File --> Target ( unable to fetch the normalize data into target table)


Why i want this is :

The output of the routine(Transform Function) is giving as a:12,b:13,c:1456,....... I am using this routine in the transformer.
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post by Ravi.K »

I was also faced same problem. Check whether the Key fields are properly defined between input and output tab of Hashed file.
Cheers
Ravi K
Post Reply