Performance issue with CDA client while running in windows server

[neethu558588]

Hi,
We are not getting a good performance with the CDA client while running in windows server. We are trying to load the data to oracle tables. Does some one has any recommended performance tuning suggestion on running on windows server? or some benchmarks in loading data to oracle ?

I have couple of questions as well. If any one can answer them, it will be very helpful.

1. We noticed that the performance is getting delayed , since there is iteration for every row and column for the null check as well as for making the data type compatible with oracle. For the datatype conversion, has anyone did it outside of the CDA Tool during database (oracle) insert operation using loading tools. What is your experience?
2. We have noticed that CDA is connecting to S3 when doing insert to the database . If this is for the validation of the record, can GW change the logic from spawning new connections constantly ? This trips are costing us load performances.

Thanks in advance