Query Reg. Join Stage

[chandra.shekhar@tcs.com]

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??

[srinivas.g]

Like the remaining 9 tables(T2,T3...T10) will make a inner join and then a left outer join will happen on T1
I hope answered your question.

[ray.wurlod]

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.

[fmou]

left outer join throughout all the tables

[chandra.shekhar@tcs.com]

@srini and fmou
You are making me confused

@Ray
You mean to say that first left outer join will happen on T1 and T2, then result of this join will be left outer joined with T3 and so on??

[ray.wurlod]

Yes. And that's how database engines do it too.