does merge stage simulate both left outer and inner join?

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
srinivas.nettalam
Participant
Posts: 134
Joined: Tue Jun 15, 2010 2:10 am
Location: Bangalore

does merge stage simulate both left outer and inner join?

Post by srinivas.nettalam »

Please let me know whether merge stage allows left outer join and inner join.
N.Srinivas
India.
tbharathkumar
Participant
Posts: 26
Joined: Mon Aug 27, 2007 6:27 am
Location: Des Moines

Re: does merge stage simulate both left outer and inner join

Post by tbharathkumar »

Yes, assuming primary link as left link (i.e left table), select options Keep/drop for unmatched records.
Regards,
Bharath Tipirisetty
ds@tcs
Participant
Posts: 24
Joined: Thu Mar 17, 2011 6:26 am
Location: chennai
Contact:

Re: does merge stage simulate both left outer and inner join

Post by ds@tcs »

Yes.. By using Merge stage we can perform inner join and left outer join
Regards
Sankar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Use a Join stage for "true" joins. Use Merge stage for a "master and updates" model which allows you to detect unmatched masters.
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