topic Re: multi threaded data migration from single table in Talend Studio

multi threaded data migration from single table

Anonymous — Fri, 21 Jun 2019 09:47:41 GMT

Hi Team,

Kindly advise.

Does Talend have any parameter settings to enable multi threaded migration from one table to other (with out explicitly creating multiple jobs).

Warm Regards,

Rajeswary S

Re: multi threaded data migration from single table

TRF — Fri, 21 Jun 2019 09:59:37 GMT

Multithreading is not necessarily the best choice to optimize dataloading into a single table because of possible deadlocks (depending on your scenario).

You should consider bulk option for your target database engine.

Re: multi threaded data migration from single table

Anonymous — Mon, 24 Jun 2019 05:20:03 GMT

Hi,
Thank you so much for the reply, would like to know whether Talend support this option and the step to do so , if supported.

Regards,
Rajeswary S

Re: multi threaded data migration from single table

TRF — Mon, 24 Jun 2019 06:45:58 GMT

If you have Enterprise edition you can use tParallize else you need multiple jobs.
That's possible but take care of deadlocks.