Data loading to Target DB-Deadlock

[rishind]

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.

[manodwhb]

@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

[rishind]

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

[manodwhb]

@rish ind​ , if you like approach 2 is good then implement in that way.

Thanks,

Manohar