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:
You can rename the transformation and add a description on the Transformation tab.
You can add input/output ports to a Transaction Control transformation.
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.