DRS Stage versus Oracle Enterprise

[srao]

Hi All,

I have Oracle 10g database and which stage is better to connect? DRS stage or Oracle Enterprise ?

I felt better using DRS stage because there are many options in DRS stage. for ex: if I am using join stage then the keys columns should be same as in both tables if not then I can use derivation to modify the column name instead using modify stage. Please suggest which one stage I can use. Thanks

[ray.wurlod]

Define "performance" in an ETL context.

Under the covers both use OCI calls (assuming that DRS is using Oracle rather than ODBC as the database type).