Which of the following is true regarding parallel execution for databases with Talend Studio?
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.
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)