Which of the following is not a Transaction Control Variable?

2 thoughts on “Which of the following is not a Transaction Control Variable?”

1. B is the requested answer.

   Use the following variables in the Expression Editor when you create a transaction control expression:
   TC_CONTINUE_TRANSACTION. The PowerCenter Integration Service does not perform any transaction change for the current row. This is the default transaction control variable value.
   TC_COMMIT_BEFORE. The PowerCenter Integration Service commits the transaction, begins a new transaction, and writes the current row to the target. The current row is in the new transaction.
   TC_COMMIT_AFTER. The PowerCenter Integration Service writes the current row to the target, commits the transaction, and begins a new transaction. The current row is in the committed transaction.
   TC_ROLLBACK_BEFORE. The PowerCenter Integration Service rolls back the current transaction, begins a new transaction, and writes the current row to the target. The current row is in the new transaction.

   1

   Reply

2. A is the correct answer

   Transaction control variables are: TC_CONTINUE_TRANSCTION, TC_COMMIT_BEFORE, TC_COMMIT_AFTER and TC_ROLLBACK_BEFORE

   Ref: https://docs.informatica.com/data-integration/powercenter/10-2-hotfix-2/transformation-language-reference/variables/transaction-control-variables.html

   1

   7

   Reply