Saturday, November 17, 2007

Joiner

Refer to the diagram below, which shows part of a mapping. Assume that each individual transformation and transformation expression in the mapping is valid, and that the part of the mapping that is not visible (downstream of the Joiner) is valid. Select the statement that is true.






Choose Answer

(A)
The mapping is valid as it is.
(B)
The mapping is invalid because a Joiner transformation must be the first transformation after the Source Qualifier, and in this mapping there are two transformations between SQ_ITEMS and the Joiner transformation.
(C)
The mapping will be valid only if the SQ_ITEMS side of the join is designated as the detail side in the Joiner transformation.
(D)
The mapping will be valid only if the SQ_ITEMS side of the join is designated as the master side in the Joiner transformation.


Refer to the diagram below, which shows part of a mapping. Assume that each individual transformation and transformation expression is valid. Select the statement that is true.