Saturday, November 17, 2007

Update Strategy transformation

It is desired to run a session where every row that is processed by the session updates the target table based on the primary key value. Assume that the target table definition has a primary key, and all other session and mapping properties are left to their defaults. Select the statement below that is true.

Choose Answer

(A)
The only action that is necessary is to set the Treat Source Rows As session property to Update.
(B)
At least one Update Strategy transformation must be present in the mapping, and the update expression condition must be written to be true for all rows that are desired to update the target table.
(C)
At least one Update Strategy transformation must be present in the mapping, and the update expression condition must be written to be true for all rows that are desired to update the target table, and the Treat Source Rows As session property must be set to Update.
(D)
At least one Update Strategy transformation must be present in the mapping, and the update expression condition must be written to be true for all rows that are desired to update the target table, and the Treat Source Rows As session property must be set to Data Driven.