Multiple choice technology databases

Which of the following target table properties is set for Type-2 mappings.

  1. INSERT

  2. INSERT/UPDATE

  3. UPDATE

  4. UPDATE/INSERT

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

For Type-2 mappings, the target table property is set to INSERT/UPDATE. This allows the mapping to handle both inserting new records and updating existing records when tracking historical changes.