Multiple choice technology

Whenever update strategy transformation is used in mapping, the session property "Treat source rows as" will default be

  1. Insert

  2. Update

  3. Data Driven

  4. Mapping Driven

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When you use an Update Strategy transformation, the session property 'Treat source rows as' automatically changes from its default (usually 'Insert') to 'Data Driven', which means the Integration Service follows the update strategy flags set by the transformation.