DS scenario

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dudam
Participant
Posts: 11
Joined: Sun Feb 27, 2011 9:40 am

DS scenario

Post by dudam »

Hi all,

I have source Like below:

geroraghy,country,state,city
asia,india,tamilnadu,chenna

i want output as :
geroraghy,country,state,city

asia, ****,****,****,

asia,india,***,****,

asia,india,tamilnadu,*******

asia,india,tamilnadu,chennai

Can plz any one help me on this..

Thanks in Advance...
DN
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Is your intent to output 4 rows of data for each input row? If that is the case, use a transform stage with your 4 output masks and use a funnel stage to combine the data streams again to a single one.
Post Reply