Talend-Rolling back Database Data Changes After Error
Emulating transactional processing in your Talend job is important in certain ETL scenarios. This video shows you how to obtain this behavior in your job by using a Commit object and setting Auto Commit unchecked in your OpenConnection component.
WARNING: The example I showed was with SQL Server. This same technique does not necessarily work with Redshift, as I have recently found out.
( / greg-c-coopman-b07b54103 )