Multiple choice technology

When an update strategy is used in the mapping, by default________option is selected in the session properties

  1. Insert

  2. Update

  3. Data driven

  4. Delete

  5. Truncate

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

When Update Strategy transformation is used in mapping, the session property 'Treat rows as' defaults to 'Data Driven' - allowing the transformation to control row-by-row treatment via DD_UPDATE, DD_INSERT, and DD_DELETE flags.