Input to Merge Stage

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
sbass1
Premium Member
Premium Member
Posts: 211
Joined: Wed Jan 28, 2009 9:00 pm
Location: Sydney, Australia

Input to Merge Stage

Post by sbass1 »

If I have a job that does:

Seq_1 --> xfm --> Seq_1_New

Seq_2 --> xfm --> Seq_2_New

and I then want to merge Seq_1_New and Seq_2_New, how do I ensure that the Merge stage waits until the files are written?

I tried a "naked" merge stage with no input streams, but it was executing synchronously, i.e. at the same time the output files were being created.

I tried linking the merge stage with IPC, etc, but since it accepts no input I couldn't link it to any preceding stage.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use two jobs?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sbass1
Premium Member
Premium Member
Posts: 211
Joined: Wed Jan 28, 2009 9:00 pm
Location: Sydney, Australia

Post by sbass1 »

Yep, that would be a crude workaround.

Is that a tacit admission that the server merge stage is poorly designed?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

"Poor" is a value judgment. The Merge stage has to read two files; it does not have input links.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply