does merge stage simulate both left outer and inner join?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 134
- Joined: Tue Jun 15, 2010 2:10 am
- Location: Bangalore
does merge stage simulate both left outer and inner join?
Please let me know whether merge stage allows left outer join and inner join.
N.Srinivas
India.
India.
-
- 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
Yes, assuming primary link as left link (i.e left table), select options Keep/drop for unmatched records.
Regards,
Bharath Tipirisetty
Bharath Tipirisetty
Re: does merge stage simulate both left outer and inner join
Yes.. By using Merge stage we can perform inner join and left outer join
Regards
Sankar
Sankar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: