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.
You can configure the SQL transformation database connections to operate in auto-commit mode. When you configure auto-commit mode, a commit occurs when a SQL statement completes.
To enable auto-commit, select AutoCommit on the SQL Settings tab of the SQL transformation.
If HA recovery is enabled with auto-commit, the session log contains a warning message that data integrity cannot be guaranteed if the query contains an insert, update, or delete statement.