Performance Issue

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Zabeerulla
Participant
Posts: 38
Joined: Tue Jan 10, 2006 1:25 am

Performance Issue

Post by Zabeerulla »

Hi,

What is difference among the ODBC , DRS and Oracle OCI Stages in terms of performance.

Which is better to connect to Oracle 10g

Please advice
Thanks & Regards,

Zabi
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

IMHO, you've listed them from least to most desirable.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Its always the best to use a stage with native drivers, which is Oracle OCI stage. The other stages use generic drivers.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”