Multiple choice technology

Which of the following are transaction control variables?

  1. TC_CONTINUE_TRANSACTION

  2. TC_STOP_TRANSACTION

  3. TC_COMMIT_BEFORE

  4. TC_ROLLBACK_BEFORE
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Informatica provides transaction control variables for managing session commits. TC_CONTINUE_TRANSACTION keeps the transaction open, TC_COMMIT_BEFORE commits before processing, and TC_ROLLBACK_BEFORE rolls back before processing. TC_STOP_TRANSACTION is not a valid transaction control variable - the correct options for stopping are handled through transaction settings or workflow conditions, not this variable name.

Keep practicing — related questions