Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 2 jobs(1 file for each job).
These 2 files load data into same Table.
Jobs can trigger anytime as per availability of data .
For eg if job A has data availability it will load the data into target table,similarly if job B has Data Availability it will load data into target ,so there is not fixed schedule to load data into Target.
So my concern is ,if A starts loading data into target and same time B also starts loading there could be deadlock situation.How can I ensure at a time only 1 file(job) loads data into target.
how can I achieve this in Talend.
@rish ind , You need to follow any one of the approach.
1) you need create both jobs in single job to use of trigger>>on subjob ok or not.
2) you need to touch a file once the job A is completed successfully and check fro that file in job B
Thanks,
Manohar
Hi @Manohar B thanks for your reply
Scenario is like any file(job) can trigger at any time ,so if file B has data it will trigger the job and insert data into target Table, or both can trigger at same time.
Option 2 looks good
@rish ind , if you like approach 2 is good then implement in that way.
Thanks,
Manohar