Join stage clarification

vamsi.4a6 · Post by **vamsi.4a6** » Fri Jul 05, 2013 5:29 am

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?

prasson_ibm · Post by **prasson_ibm** » Fri Jul 05, 2013 6:28 am

In this case all records from the left will move to output link with matching records from Intermediate1 ,Intermediate2 and right link.

ray.wurlod · Post by **ray.wurlod** » Fri Jul 05, 2013 3:35 pm

Multi-input left outer join works the same way it does in a query engine. Essentially pairwise, left to right.