Saturday, November 17, 2007

3 or more data sources connected to a Joiner

Choose Answer

(A)
The mapping is valid as it is.
(B)
The mapping is invalid because there is an active transformation between SQ_ITEMS and the Joiner transformation. If the Aggregator transformation was eliminated or replaced with a passive transformation, the mapping would be valid.
(C)
The mapping is valid only if the SQ_ITEMS side of the join is designated as the master side in the Joiner transformation.
(D)
The mapping is invalid because it is not permitted to have three or more data sources connected to a Joiner transformation under any circumstances.