The Updater Properties define how backend data will be updated with data from the XML document.
When you double-click on the Updater icon, the Workbench displays the Updater properties dialog
The Allow creates, Allow deletes, and Allow updates checkboxes specify whether to allow those changes to the Repository. The rows udpated are defined by the Key Columns for updating table. Specify the columns used to determine the records to update in this table.
When you have specified a set of key columns, click the [Check key against unique indexes] button to confirm that all of the selected keys exist and are valid.
Transaction Manager
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.