DRS, Oracle OCI and Oracle Enterprsie

[Aquilis]

Hi All,

DRS, Oracle OCI and Oracle Enterprise supports partitioning feature. We are going to use Oracle 10g DB for source and target. In existing system DRS stage is used with Server jobs. We are migrating to DS EE for performance enhancement. Data will range from 100 KB to 2 GB per source. Many such job having 2 GB source file jobs may run concurrently to load data into DB tables.
I know that DRS is primarily required if there is a possibility of changing the DB in future.
Which stage will better suite here?

Thanks in advance.
-Aquilis

[chulett]

For PX jobs, you are going to want to use 'Enterprise' stages.

[Aquilis]

Hi Chulett,
Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?
Thanks in advance.
-Aquilis

[Aquilis]

Hi Chulett,

Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?

Thanks in advance.
-Aquilis

[Aquilis]

Hi Chulett,

Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?

Thanks in advance.
-Aquilis

[Aquilis]

Hi Chulett,

Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?

Thanks in advance.
-Aquilis

[Aquilis]

Hi Chulett,

Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?

Thanks in advance.
-Aquilis

[DSguru2B]

You dont have to post multiple times or was that just a glitch?
Anyhow, read about the enterprise stages and how it can utilize parallism while loading data.

[Aquilis]

Hi Chulett,

Can you elaborate why Oracle enterprise stage is better than OCI and DRS in terms of performance?

Thanks in advance.
-Aquilis

[ray.wurlod]

Define "performance" in an ETL context.

Rows/sec is, as I have frequently asseverated, meaningless.

[chulett]

I guess that's one way to get your post count up quickly.

The Oracle Enterprise stage is the only one native to the Parallel engine.

[sanjay]

Hi
Oracle enterprise stage is better but has 1 problem it require access to some dba related tables which due to security reason its very difficult to convince client or dba.

Sanjay

I guess that's one way to get your post count up quickly.

The Oracle Enterprise stage is the only one native to the Parallel engine.

[chulett]

It requires SELECT privileges on some DBA views so it can function properly. Nothing more. There's no reasonable "security reason" that should disallow that.

[Nagaraj]

I read the whole documentation for Oracle OCI and oracle ENterprise
and odbc connector and odbc enterprise...
just some options differences here and there....!

Can any one please give me cut throat defintions about these stating the differences b/w oracle enterprise and oracle oci, odbc connector and odbc enterprise stage?