What is the difference between ODBC and OCI stage in server job?

I am new to data stage, so I am a bit confused when to use ODBC and when OCI.Added to it I saw the question where it was asked how to remove duplicate records in the target and many of them answered that you need to use a aggregator to count on the key if its more than 1 it has a duplicate value then you need to remove that but how can a key have duplicate value?

Questions by aurchwd

Showing Answers 1 - 2 of 2 Answers

veer.dwh

  • Sep 19th, 2009
 

The difference b/w ODBC and OCI is, odbc supports to read or write any kind of relational DB but OCI supports only oracle DB.

For suppose if you want read a oracle table in DS in that case if you use odbc it wont give you good performance but oci will give good performance.

Regards,
Veeru.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions