Saturday, November 17, 2007

Outer join

Can a Source Qualifier be used to perform an outer join when joining two database tables?

Choose Answer

(A)
Yes, but it requires that the user modify the join SQL by hand.
(B)
Yes, but it requires that the user select left or right outer join as the Source Qualifier Join Type property.
(C)
No, because this may produce null values in ports and the Source Qualifier does not support default values.
(D)
No, this function is not supported by the Source Qualifier- a Joiner transformation would need to be used.

No comments: