DSXchange

Hi,

This may be old question but asking it again, could not find in search.

According to documentation the Oracle connector stage offers better functionality and performance replacing some stages which have been deprecated. Is there a real functionality difference in the way the oracle connector stage and enterprise stage connects and calls Oracle statements?
I assume both the stages in 8.5 writes the data in array and writes using Oracle host-array processing. If both use the same method of writing to database, is there a real performance difference (other than functionality)?

Oracle connector is said to be 20% faster than oracle enterprise stage as it uses its own API while the oracle enterprise stage uses Oracle clients API. Although the oracle connectors API still uses the oracle libraries but not the application.