The Lifeline of Informatica –Transformations - Learning Informatica PowerCenter 9.x - page 369

4. Double-click on the Transaction Control transformation and click on Properties .
We need to define the condition in the Transaction Control transformation expres-
sion editor, as shown in the following screenshot:
5. Finally, click on OK .
The mapping using the Transaction Control transformation is now complete.
The Transaction Control transformation supports the following built-in variables in the
expression editor:
• TC_COMMIT_BEFORE : Integration Service commits the current record, starts
processing a new record, and then writes the current row to the target.
• TC_COMMIT_AFTER : Integration Service commits and writes the current record
to the target and then starts processing the new record.
• TC_ROLLBACK_BEFORE : Integration Service rolls back the current record,
starts processing the new record, and then writes the current row to the target.
• TC_ROLLBACK_AFTER : Integration Service writes the current record to the tar-
get, rolls back the current record, and then starts processing the new record.