topic Re: Run Multiple Netezza Queries at a time in Talend Studio

Run Multiple Netezza Queries at a time

javvaji — Wed, 28 Jun 2017 13:06:09 GMT

Hi,

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,

Bharath.

Re: Run Multiple Netezza Queries at a time

TRF — Wed, 28 Jun 2017 13:10:43 GMT

Probably you need multiple connections if you have multiple queries in parallel at the same time.

Re: Run Multiple Netezza Queries at a time

javvaji — Wed, 28 Jun 2017 14:42:13 GMT

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.

Thanks,

Bharath.

Re: Run Multiple Netezza Queries at a time

TRF — Wed, 28 Jun 2017 14:44:30 GMT

No sure to understand your last question, sorry.

Re: Run Multiple Netezza Queries at a time

javvaji — Wed, 28 Jun 2017 14:49:31 GMT

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.

Thanks,

Bharath.

Re: Run Multiple Netezza Queries at a time

TRF — Wed, 28 Jun 2017 15:00:35 GMT

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.

Re: Run Multiple Netezza Queries at a time

javvaji — Wed, 28 Jun 2017 15:12:51 GMT

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.

Thanks,

Bharath.

Capture.PNG

Re: Run Multiple Netezza Queries at a time

Anonymous — Tue, 19 Dec 2017 22:44:42 GMT

You should need to ask your database admin to allow multiple threads sharing the single database connection.

Thanks,

VENKATA

Re: Run Multiple Netezza Queries at a time

javvaji — Thu, 21 Dec 2017 14:26:34 GMT

Thanks for the reply venkata.

I will try it and let you know.

Thanks,

Bharath.