Scenario: Rollback from inserting data in mother/daughter tables - 6.1

Talend Open Studio for Big Data Components Reference Guide

Talend Open Studio for Big Data
Data Governance
Data Quality and Preparation
Design and Development
Talend Studio

Based on Scenario 1: Inserting data in mother/daughter tables, insert a rollback function in order to prevent unwanted commit.

  1. Drag and drop tMysqlRollback to the design workspace.

  2. Connect tFileList to tMysqlRollback with an OnSubjobError trigger.

  3. Double-click tMysqlRollback to enter its Basic settings view.

  4. From the Component List, select the connection component.

tMysqlRollback ensures that the transaction will not be partly committed.