Oracle Enterprise and OCI Stages

saikir · Post by **saikir** » Tue Jun 03, 2008 2:07 am

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

mandyli · Post by **mandyli** » Tue Jun 03, 2008 2:25 am

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

saikir · Post by **saikir** » Tue Jun 03, 2008 10:24 pm

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

Brian Zhang · Post by **Brian Zhang** » Tue Jun 03, 2008 11:25 pm

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

saikir · Post by **saikir** » Wed Jun 04, 2008 12:36 am

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

Minhajuddin · Post by **Minhajuddin** » Wed Jun 04, 2008 10:45 am

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.