I need to run multiple netezza input components in parallel.So in my job i used tParallelize component and running two tNetezzaInput components at a time. Here i used "allowMultiQueries=true" in Advanced JDBC Parameters in tNetezzaConnection component. But still i was unable to run multiple at a time.
So can some one help me on this.
Thanks for your reply.
It's working, but if in that case if we have more than two tables it will increase the components right.So what would be the solution in that case.
As per your comment multiple connections is working, but if i need to load 10 tables parallely then i need to create 10 connection components right. so it would increase the components right. So do we have any another option.
I don'tt really understand the meaning of "it would increase the components right".
However, I'm afraid you have to do that, I've already met the same situation with Salesforce.
I mean database connection components will increase. Here i attached the screen shot of job, in this job i was trying to load for two tables if we want to load more than two tables we need to add connection component for every table.
You should need to ask your database admin to allow multiple threads sharing the single database connection.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.