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?
Join stage clarification
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
In this case all records from the left will move to output link with matching records from Intermediate1 ,Intermediate2 and right link.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: