How to use strat transaction commit rollback in TALEND

Six Stars

How to use strat transaction commit rollback in TALEND

I have a job which has multiple tables involved in transaction .

1>How do I use commit and rollback, Basically on which place to be used, as I have so many sub jobs connected.

2>Where to use on component OK & where to use On sub job OK. My job is working fine. But I need to know the particular use.

 

Capture.JPG

 

 

Kindly help.

Eight Stars

Re: How to use strat transaction commit rollback in TALEND

Hello,

 

Ad 1)

Example how to implement commit -

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/yuU8JtnIXUBiRsJYYKOngA?section=Raa91640

Example how to implement rollback - 

https://help.talend.com/reader/WWQ40R_iTE5~~9VkUQrjgQ/7THiSA~u~mPb7PskcQONMQ

 

ad 2) OnComponentOK - for a single component check, OnSubJobOK - when you need to check that all components in the subjob finished successfully.

 

Regards
Lojdr

Six Stars

Re: How to use strat transaction commit rollback in TALEND

Ok. Thanks. But how to design when there are multiple transformation on a same job.

 

for example

tmysqlinput1>> tmp>>tmysqloutput1 

 

tmysqlinput2>> tmp>>tmysqloutput2

 

tmysqlinput3>> tmp>>tmysqloutput3

Here I need all table load happens once or none. from youe suggestion I can go for individual commit & rollback but what about whole thing.

Please suggest

Eight Stars

Re: How to use strat transaction commit rollback in TALEND

Hello,

 

There is no easy solution of this task. The only correct solution is to do it in one transaction to be sure that data will stay consistent. As far as I know, there is no possibility to commit several transaction as a one. It is always one by one and this can cause inconsistency.

I recommended one solution/workaround for MySQL in the following thread:

https://community.talend.com/t5/Design-and-Development/delay-commit-when-using-built-in-mode-tMysqlO...

 

Please check it and let me know.

 

Regards
Lojdr

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download