DSXchange

hi
my question is while using oracle database as source or target why we will use OCI stage why don't we use ODBC stage ?

Please do a better job of choosing Subjects for your posts, it should be specific to your question or problem. At least you didn't just say "Hi" like we've seen in the past.

As to your question, why would you want to use ODBC over a native stage for any database? To me, ODBC is the 'stage of last resort', something you use when you have no other choice. For Oracle, that might be the situation when installing an Oracle client on your DataStage server is (for whatever reason) not possible.

Because OraOCI stage is the native stage available for connecting to Oracle database. The performance is faster with the OCI stage than using ODBC stage. As Chulett mentioned, ODBC stage is used only in a case where native Database stage is not available.