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

GeekInterview.com > Tech FAQs > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 20 of 140

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

Total Answers and Comments: 4

Last Update: May 29, 2008 Asked by: jaggu

Sponsored Links

Best Rated Answer

—

Submitted by: sudhakar.netha

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.

Above answer was rated as good by the following members:
balamura

April 27, 2006 21:29:13

sam

RE: While using oracle database as target or Source wh...

Useing OCI we can transefer the data rather than ODBC

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

Is this answer useful? Yes | No

March 26, 2007 01:50:29

rajenmari

Member Since: March 2007 Contribution: 6

RE: While using oracle database as target or Source wh...

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.

Is this answer useful? Yes | No

April 19, 2007 06:04:42

pumabhanu

RE: While using oracle database as target or Source wh...

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.

Is this answer useful? Yes | No

May 29, 2008 10:29:50

sudhakar.netha

Member Since: January 2008 Contribution: 2

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

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.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank