Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

multi threaded data migration from single table

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

 

Labels (2)
1 Solution

Accepted Solutions
TRF
Champion II
Champion II

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

View solution in original post

3 Replies
TRF
Champion II
Champion II

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
Not applicable
Author

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
Champion II
Champion II

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