multi threaded data migration from single table

[Anonymous]

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

[TRF]

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.

[Anonymous]

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

[TRF · Accepted solution]

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