While using oracle database as target or Source why we will use OCI stage why don't we use ODBC stage?

sam

• Apr 27th, 2006

 

Useing OCI we can transefer the data rather than ODBC

OCI supports OraBulk and PlugIns useing these concepts Bulk loads possible quickly

rajenmari

 Profile Answers by rajenmari 

• Mar 26th, 2007

 

Since OCI is Oracle Connectivity Interface.so connect to oracle we have have user drivers which specified by oracle not  the drivers od some other software.

pumabhanu

• Apr 19th, 2007

 

While using Oracle Database as source we use oracle enterprise stage, because it retrieves bulk of data fastly, where as the odbc stage has drivers and are slow while retreving bulk of data.

sudhakar.netha

 Profile Answers by sudhakar.netha 

• May 29th, 2008

 

The reason is performance,OCI stage is faster while dealing with bulkdata and where it comes to ODBC stage its slow.But one thing ther is no rule that we Should use only OCI stage while dealing with oracle database.