Multiple choice technology databases

Select the which entry we have to made in treat source as option in session properties if we want map to handle insert and update?

  1. Insert

  2. Data driven

  3. Update

  4. Delete
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The 'Data driven' option allows the mapping to handle both inserts and updates based on flags set in the data flow. When selected, Informatica uses the update strategy flags (DD_INSERT, DD_UPDATE, DD_DELETE) set within the mapping to determine the operation type for each row. This enables a single session to perform different DML operations dynamically.

Keep practicing — related questions