PowerCenter
All Products
Property | Target-Based | Source-Based | User-Defined |
---|---|---|---|
Commit Type | Selected by default if no transaction generator or only ineffective transaction generators are in the mapping. | Choose for source-based commit if no transaction generator or only ineffective transaction generators are in the mapping. | Selected by default if effective transaction generators are in the mapping. |
Commit Interval | Default is 10,000. | Default is 10,000. | n/a |
Commit on End of File | Commits data at the end of the file. Enabled by default. You cannot disable this option. | Commits data at the end of the file. Clear this option if you want the Integration Service to roll back open transactions. | Commits data at the end of the file. Clear this option if you want the Integration Service to roll back open transactions. |
Roll Back Transactions on Errors | If the Integration Service encounters a non-fatal error, you can choose to roll back the transaction at the next commit point. When the Integration Service encounters a transformation error, it rolls back the transaction if the error occurs after the effective transaction generator for the target. | If the Integration Service encounters a non-fatal error, you can choose to roll back the transaction at the next commit point. When the Integration Service encounters a transformation error, it rolls back the transaction if the error occurs after the effective transaction generator for the target. | If the Integration Service encounters a non-fatal error, you can choose to roll back the transaction at the next commit point. When the Integration Service encounters a transformation error, it rolls back the transaction if the error occurs after the effective transaction generator for the target. |
Updated November 14, 2019