topic Data loading to Target DB-Deadlock in Talend Studio

Data loading to Target DB-Deadlock

rishind — Sat, 16 Nov 2024 01:18:47 GMT

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.

Re: Data loading to Target DB-Deadlock

manodwhb — Mon, 12 Oct 2020 12:58:30 GMT

@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

Re: Data loading to Target DB-Deadlock

rishind — Mon, 12 Oct 2020 13:51:00 GMT

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

Re: Data loading to Target DB-Deadlock

manodwhb — Mon, 12 Oct 2020 14:18:57 GMT

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

Thanks,

Manohar