Transfer data from Informix to Oracle using DOA

[giga]

Hi man, can you help me?
I want transfer data from Informix to Oracle. I am reading data (millions of records in many tables) using BDEDataSet. And I want write it into oracle - which is best - Array DML or TOracleDirectPathLoader? TOracleDirectPathLoader and Array DML requires data in memory (and I have data in BDEDataSet or in ClientDataSet) - how can I do it with best performance?

Thx.
Sorry my poor English, but it isn't my natural language.

 

[Marco Kalter]

The TOracleDirectPathLoader will give the best performance. Records are loaded in batches, and for each batch of records you need to load the data from the BDEDataSet into memory.

Array DML is easier to program and does not have any of the Direct Path restrictions regarding triggers and constraints. It may be that performance is already sufficient.