Page 1 of 1

Join stage clarification

Posted: Fri Jul 05, 2013 5:29 am
by vamsi.4a6
I am analyzing existing Job in Datastage.Could anybody please clarify below doubt with respect to Join stage?

I have 4 Tables.These four tables are input to Join stage.Join type=Left outer.In link ordering tab following details are mentioned.

Table1-Left

Table2-Intermediate1

Table3-Intermediate2

Table4-right

I know how left outer join works if it is two inputs to join stage and in this case i am unable to understand how join operation will be performed?

Posted: Fri Jul 05, 2013 6:28 am
by prasson_ibm
In this case all records from the left will move to output link with matching records from Intermediate1 ,Intermediate2 and right link.

Posted: Fri Jul 05, 2013 3:35 pm
by ray.wurlod
Multi-input left outer join works the same way it does in a query engine. Essentially pairwise, left to right.