Share
Report
18Hi All,
Good day!!
I have a use case where I need to populate around 1.6k records in a Oracle table from a csv file on share point.
I am using Oracle premium connector and Insert row step to do this but for 1.6k records with concurrency control its taking almost an hour to populate the data.
To optimize this I tried to create the Insert All statement and use the Execute Query step, but the step is failing because of the \r\n for new lines.
Can anyone please advise how can we optimize and increase the speed to data entry into table.
Thanks and Regards,
Sathish.
Categories:
I have the same question (0)
All responses (
Answers (
