Can we use multiple Merge stages in 1 job

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
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Can we use multiple Merge stages in 1 job

Post by vinaymanchinila »

Hi,
I have one source file which needs to be merged with 8 files seperately. Can I use all of them in one job, or will there be a issue.
What I wnat to do is :

Merge1(Srcfile+ref1)--Tx--Target1
Merge2(Srcfile+ref2)--Tx--Target2
.
.
.
Merge8(Srcfile+ref8)--Tx--Target8

As all my Merge stages use the same source file, will it hang or will it be ok to use it as I have different targets ?.
Thanks,
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Multiple readers are fine, it's multiple writers to the same sequential source that is a problem. So as long are your targets (if they are flat files) are unique you should be fine.
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Thanks Craig,
The "writers" are not the same, and I am also using a Link Colector followed by an Aggregator stage to sum the vlaues up, hope this will not be a issue , in the sense the aggregator will wait till all the records are processed.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Sounds ok. If there does turn out to be an issue, let us know and we'll work through it. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Yep, will try it tomorrow and let you guys know!
Thanks a bunch
Post Reply