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?

veer.dwh

 Profile Answers by veer.dwh Questions by 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.

Answer Question  Select Best Answer