How to read Data in parallel Using Netezza connector Stage

[akshyat]

I have been trying to configure the netezza connector stage to read data in parallel.

So far I have been able to achieve the following:

a) Read data in parallel using an Auto query.
b) Reading Data in parallel using user defined simple query. - In order to achieve this we have to use the place holder condition in the where clause
AND mod(datasliceid,[[node-count]])=[[node-number]]

However, when my user defined query becomes complex involving joining of tables I am not able to read the data in parallel.

Any thoughts on how to achieve that?

Thanks