Saturday, November 17, 2007

Sorter transformation

Select the statement below that is true.

Choose Answer

(A)
The Sorter transformation must be used immediately downstream of a Source Qualifier transformation.
(B)
The Sorter transformation must be used immediately downstream of a Source Qualifier transformation that reads from a relational source.
(C)
The Sorter transformation supports multiple sort levels, so any sort key can have a secondary sort associated with it.
(D)
The user is allowed to modify the ORDER BY clause generated by the Sorter transformation.