topic Parallel Execution in Talend Studio

Parallel Execution

Anonymous — Sat, 16 Nov 2024 09:25:20 GMT

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

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

Multiple Ans-

Re: Parallel Execution

Anonymous — Wed, 23 Aug 2017 10:59:17 GMT

Hi,

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

Sabrina

Re: Parallel Execution

Anonymous — Tue, 12 Sep 2017 05:27:06 GMT

Hi,

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)

Thanks