HI,
I have a small query. If I am having 10 Src table(T1,T2...T10) and I am using a Join stage after the Src, keeping left outer join as join type. Then what will be my output like?
Like the remaining 9 tables(T2,T3...T10) will make a inner join and then a left outer join will happen on T1? Or Will it be a left outer join throughout all the tables??
Query Reg. Join Stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Query Reg. Join Stage
Thanx and Regards,
ETL User
ETL User
-
- Participant
- Posts: 251
- Joined: Mon Jun 09, 2008 5:52 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The same join type is used pairwise on all input links to the Join stage. (Join type can only be set once in the stage.) Specify the join type that you actually require.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: