Transformation: Referring to Active and Passive characteristics – Select the statement which is correct and true.
A. If a transformation’s Active property is cleared or not enabled, the transformation becomes passive
B. A transformation is active if it does not change the number of rows in the pipeline
C. Transformations can be active and passive at the same time
D. A passive transformation will not change the number of rows in the pipeline
D is the correct answer.
Why not A? The property “is active” is enabled and cannot be edited, so active transformations can not become passive transformations.
Why not B? A transformation is PASSIVE if it does not change the number of rows in the pipeline
Why not C? Transformations can NOT be active and passive at the same time.