Saturday, November 17, 2007

Sorted Input in Aggregator transformation

An Aggregator transformation has two group-by ports: CUSTOMER_ID and ORDER_DATE, in that order. The Sorted Input property is set to true. The Order By clause in the SQL for the Source Qualifier contains this syntax: ORDER BY CUSTOMER_ID, ORDER_DATE, MANF_ID. Assuming that the sort order on the database server matches the sort order of the session and everything else is valid, what would happen when this session started?

Choose Answer

(A)
The session would run normally.
(B)
The session would fail, because the columns in the ORDER BY clause in the SQL do not exactly match the group-by ports in the Aggregator transformation.
(C)
The session would fail, because when the Sorted Input property is set to true, no more than one group-by port is allowed.
(D)
The session would run, but sorted data would not be used because the columns in the ORDER BY clause in the SQL does not exactly match the group-by ports in the Aggregator transformation, and this may adversely affect performance.

No comments: