topic Re: How to do insert,update,delete operations on same table on same time in Talend Studio

How to do insert,update,delete operations on same table on same time

Anonymous — Thu, 25 Feb 2016 09:52:55 GMT

Hi all,
i am new to Talend Data integration open studio.Currently i am facing one issue in my project.Can any one help me to solve my issue.
Issue: It is possible to insert,update,delete operations on same table on same time in postgresql database.
I have developed job which has 4 sub jobs.The first job should insert records into db table and second and third sub jobs are update db table for particular records .The fourth sub job is delete the particular records in db table based on some condition.
My problem is run all these 4 sub jobs parallel for every sec then first sub job insert the db table and second sub job only update records in db table but third sub job is run but not updated in db table.

Re: How to do insert,update,delete operations on same table on same time

Anonymous — Fri, 26 Feb 2016 08:45:36 GMT

Should these not be sequential processes? You may be deleting a record you're updating or updating before the record is inserted?

Re: How to do insert,update,delete operations on same table on same time

Anonymous — Sat, 27 Feb 2016 04:57:08 GMT

Pradeep if you are experimenting ,go ahead and try it,but if its a business requirement kindly explain more what needs to be achieved.