Parallel Execution

[Anonymous]

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-

[Anonymous]

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

[Anonymous]

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