Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
Use the Transaction Control transformation to define conditions to commit and roll back transactions from transactional targets. Transactional targets include relational, XML, and dynamic MQSeries targets. Define these parameters in a transaction control expression on the Properties tab. A transaction is the row or set of rows bound by commit or roll back rows. The number of rows may vary for each transaction.
When you configure a Transaction Control transformation, you define the following components:
Transformation tab.
You can rename the transformation and add a description on the Transformation tab.
Ports tab.
You can add input/output ports to a Transaction Control transformation.
Properties tab.
You can define the transaction control expression, which flags transactions for commit, roll back, or no action.
Metadata Extensions tab.
You can extend the metadata stored in the repository by associating information with the Transaction Control transformation.