Four Stars

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

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.  
2 REPLIES
One Star

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

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

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

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