Hi ,
I have an issue with my client, they have processed 100k sheets and complete all verification now they have to export data in Oracle DB
so they configure export setting , Connection string and then finally created tables but in table structure some fields are automatically created float data type column for numbers and while exporting null value to float ( null able configure) 0 is being exported.
At this very stage they can not change definition and change data type or process as text setting so they have manually change column type to nvarchar in table.
Now every thing is ok for few batchs null is move as null but after exporting few batches speeding became extremely slow even hours need to export 100 sheets that normally took
few mnts.
Kindly update urgently.
Exporting data to DB speed become extreemly slow after change table datatype Answered
Was this article helpful?
0 out of 0 found this helpful
Comments
1 comment
Hello,
The solution of the issue may require gathering of detailed information about your complex and even the remote session may be needed. Please contact your regional support.
Please sign in to leave a comment.