Partition reads were not enabled

RK72 · Post by **RK72** » Tue Sep 20, 2011 2:42 pm

My job extract from database connector stage is saying that Partition reads were not enabled so its running sequentially how to enable it and make it parallel so that it extracts data parallely.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2011 3:03 pm

Depends. It may not even be possible. Which particular Connector stage?

suse_dk · Post by **suse_dk** » Tue Sep 20, 2011 3:03 pm

Set "enable partioned read" to true in the ODBC Connector. Then choose between a modulus or range partitioning method.

RK72 · Post by **RK72** » Tue Sep 20, 2011 4:28 pm

Its Oracle connector stage.

chulett · Post by **chulett** » Tue Sep 20, 2011 5:53 pm

Your source table must be partitioned in order to enable that, is it?

ray.wurlod · Post by **ray.wurlod** » Tue Sep 20, 2011 7:33 pm

You need to set the Partition Table property.