Page 1 of 1

Issue when we change join type from left to right outer

Posted: Sat Sep 25, 2004 12:52 am
by dsxdev
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.

Posted: Tue Sep 28, 2004 1:18 pm
by gh_amitava
Hi,

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

Regards
Amitava