In Informatica PowerCenter, the Transaction Control transformation uses five predefined, built-in variables to manage transaction boundaries. These variables are TCCONTINUETRANSACTION, TCCOMMITBEFORE, TCCOMMITAFTER, TCROLLBACKBEFORE, and TCROLLBACKAFTER. The variable TCCOMMITTRANSACTION is not a valid, recognized built-in variable within the Informatica transaction control logic. The commit actions must specify whether the operation occurs before or after processing the current row, which is why TCCOMMITBEFORE and TCCOMMITAFTER exist.

A. TCCONTINUETRANSCTION: Incorrect. Despite the misspelling ("TRANSCTION"), this option clearly refers to the valid variable TCCONTINUETRANSACTION, which instructs the Integration Service to continue processing rows within the current transaction.

C. TCROLLBACKBEFORE: Incorrect. This is a valid built-in variable. It instructs the Integration Service to roll back the current transaction before processing the input row that evaluates to this condition.

D. TC COMMIT AFTER: Incorrect. Despite the improper formatting (space instead of an underscore), this option refers to the valid variable TCCOMMITAFTER, which instructs the Integration Service to commit the transaction after processing the current row.

1. Informatica PowerCenter 10.5

Transformation Language Reference

Chapter 19: Transaction Control Transformation

"Transaction Control Expression" section.

Page 388: This section explicitly lists the five built-in variables for transaction control: TCCONTINUETRANSACTION

TCCOMMITBEFORE

TCCOMMITAFTER

TCROLLBACKBEFORE

and TCROLLBACKAFTER. The variable TCCOMMITTRANSACTION is absent from this official list.

2. Informatica PowerCenter 10.2.0

Transformation Guide

Chapter 22: Transaction Control Transformation

"Configuring a Transaction Control Transformation" section.

Page 435: The guide details the use of the transaction control expression and its variables. It states

"The return value of the expression determines how the Integration Service handles the transaction." It then lists the five valid integer constants

confirming that TCCOMMITTRANSACTION is not a valid constant.