Parallel Execution

Five Stars

Parallel Execution

Which of the following is true regarding parallel execution for databases with Talend Studio?

  1. You must run your Job on a system with multiple cores or processors for it to be an advantage
  2. The parallel execution is for the component itself and not the containing subjob
  3. You set it on specific database components
  4. It is independent of multithreaded execution
  5. The number of processors the component can use display in the design workspace

Multiple Ans-


Re: Parallel Execution


For your multiple answer, we have redirected your issue to our expert and then come back to you as soon as we can.

For DB parallel execution, usually "use parallel execution" option is supported on the t<DB>output component which is used to perform high-speed data processing, by treating multiple data flows simultaneously. Note that this feature depends on the database or the application ability to handle multiple inserts in parallel as well as the number of CPU affected.

And there is also tParallelize component which allows you to synchronize the execution of a subjob with the execution of other subjobs in your main Job.

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Parallel Execution


The parallel execution for database is component specific and not for the the entire sub job. You can enable in the t<DB>output advance setting. So the option (B) is correct one.This setting is for faster insertion or update in database but it depends on your database setting as well. Here option (C) is also correct  because it is component specific.


 The number of processors the component can use display in the design work space so this is also correct option (E). The concept of parallel execution and multi threading is different hence it is independent of multi threaded execution.(D)


So the correct Answer- (B,C,D,E)






Talend named a Leader.

Get your copy


Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables


Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema


Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables