Multiple choice technology databases

Which of the following can be used in an Update Strategy transformation?

  1. DD_INSERT

  2. DD_UPDATE

  3. DD_DELETE

  4. DD_TRUNCATE
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Update Strategy transformation supports DD_INSERT, DD_UPDATE, and DD_DELETE operations for handling database changes. DD_TRUNCATE is not a valid operation type in this transformation - it's typically a database-level operation performed separately.

AI explanation

In Informatica PowerCenter's Update Strategy transformation, each row is flagged for a target operation using the constants DD_INSERT (0), DD_UPDATE (1), DD_DELETE (2), and DD_REJECT (3) — DD_INSERT, DD_UPDATE, and DD_DELETE are all valid. There is no DD_TRUNCATE constant; truncating the target table is a session/target-load-type option ("Truncate Target Table"), not a row-level Update Strategy flag, so it's correctly excluded.

Keep practicing — related questions