DSXchange

Hi All,

I am new to parallel and learning most of the stuff by reading the documentation. I would like to know the difference between Oracle Enterprise Stage and Oracle OCI Stage?

Is it like Enterprise can be run in parallel and OCI in sequential mode?

Could any one plz explain me the difference?

Sai

Welcome to Datstage..

Is it like Enterprise can be run in parallel and OCI in sequential mode?

Yes. You are right.
Enterprise stage will support parallel extraction but OCI will not support its like API stage.


Thanks
Man

Hi Man,

Thanks for the reply. In continuation, can i use an OCI stage in a parallel job , if i prefer to load data sequentially?

Sai

saikir wrote:Hi Man,

Thanks for the reply. In continuation, can i use an OCI stage in a parallel job , if i prefer to load data sequentially?

Sai

When you are not able to reach source DB directly and there is no partitioning optimization on tables in source DB, then you could perform a parallel process during source data reading manually.

Split to several source instances with different user-defined SQL. Perform a range limitation on WHERE clause in each souece instance. Then, when the job running, the process at source pipeline would be perform as Key-range Partition, and those read threads are running concurrently.

Thanks
Brian

Hi All,

I am still not clear. Assume that i have created a parallel job to read data from a file and to load into an oracle table. Now to load into the database can i use the Oracle OCI Stage or this stage is only applicable for sever jobs?

If you are using a parallel job, then do you always have to use the Oracle Enterprise stage

Regards,
Sai

All the stages present in the "parallel job palette" can be used in a parallel job. The palette you see to the left in the Datastage designer changes based on the type of job you develop, So when you develop a parallel job you can not (can not as in you won't be able to not that you shouldn't )use server job stages.