tMSSqlCommit
Commits in one go, using a unique connection, a global transaction instead of doing that on every row or every batch and thus provides gain in performance.
tMSSqlCommit validates the data processed through the Job into the connected DB.
For more technologies supported by Talend, see Talend components.