Join stage clarification
Posted: 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?
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?