The Transaction Manager defines transaction behavior for update resources. In Percussion, a transaction defines a set up update actions to the Repository (whether inserts, updates, or deletes). Transactions are valuable when in case failures occur when multiple tables are updated at the same time. Updating all tables in on transaction guarantees that all tables stay synchronized. If modifications to one of the tables in the transaction fails, changes to other tables will not be applied.
.
When you double-click on the Transaction Manager icon, the Workbench displays the Transaction Manager Properties dialog.
If it is important to maintain data integrity across multiple tables, but not necessarily for the entire data set, select the One row at a time radio button. If you need to maintain integrity across the entire data set, select the All rows together radio button.