Query regarding merge stage

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
suchit1983
Participant
Posts: 9
Joined: Thu Nov 29, 2007 10:45 pm

Query regarding merge stage

Post by suchit1983 »

Hi,

I am new to DataStage PX. I have a query regarding Merge stage.

What kind of join does it do? Is it a left outer join?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Welcome.

Seems to me that it would depend on the Unmatched Masters Mode setting. The default of 'Keep' could be thought of as a left outer join, while 'Drop' would equate to an inner join.

That from the Parallel Job Developer's Guide pdf Merge Stage chapter.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply