Issue when we change join type from left to right outer

dsxdev · Post by **dsxdev** » Sat Sep 25, 2004 12:52 am

Hi,
We are facing a problem when ever we change the join type.
We have two inputs to a join Stage link A and link B
A-left
B-right and join type Left outer join.

This combination works.

But when we change the order of the links

A- rigth
B- left

Now we use right outer join.

gh_amitava · Post by **gh_amitava** » Tue Sep 28, 2004 1:18 pm

Hi,

Datastage left outer and right outer join works like database. If you change the link ordering, it will work differently.

Regards
Amitava