DSXchange

Hi,

I am using Oracle Enterprise stage in Datastage PX v7.5.1. The stage showing execution mode as sequential only while reading from the oracle 10g table. How can I make it to parallel as the execution method is set to sequential by default and not allowing me to change to parallel as it is disabled.

Thanks in Advance.

Tushar

And it is documented as behaving thus for SELECT.
If you set the Partition Table property then its execution mode may be able to be set to parallel but otherwise you're limited to sequential. This is because of how Oracle delivers its results; they are stored in a temporary table (whether in memory or on disk) and these results are streamed to the requesting client.