Multiple choice technology platforms and products

If you do not choose Data Driven when a mapping contains an Update Strategy transformation , which of the following is true ?

  1. The mapping gets invalidated

  2. The Workflow Manager displays a warning

  3. The Informatica Server does not follow instructions in the Update Strategy transformation in the mapping to determine how to flag rows.

  4. The Informatica Server does follow instructions in the Update Strategy transformation in the mapping to determine how to flag rows
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Without Data Driven enabled, the Integration Service treats all rows as inserts by default. The Update Strategy transformation's DD_UPDATE, DD_DELETE, and DD_REJECT flags are completely ignored, effectively neutralizing its purpose in the mapping.

Keep practicing — related questions