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
Oracle Enterprise and OCI Stages
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Tue Jun 03, 2008 12:13 am
- Location: Melbourne
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.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
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
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
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
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.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>