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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables