Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
MichaelWee
Contributor
Contributor

Replicate - Oracle Clob to SQL Server

We have to move Oracle tables to SQL Server.  Any Oracle table with a column with CLOB data type, Takes up to 15 + hours for a full load.  Any suggestions?  I tried enabling LOB columns with different sizes and unlimited sizes.   Does anyone have some insight on how to improve performance?    Thanks!

Labels (1)
2 Replies
john_wang
Support
Support

Hello @MichaelWee ,

If you are meaning a single table full load takes up too long time then you can use Parallel Load  to accelerate the replication of large tables by splitting the table into multiple segments and loading the segments in parallel.

Also please check the Handling LOB columns , hope this helps.

Regards,

John.

MichaelWee
Contributor
Contributor
Author

Thank you.   Any observations on Incremental load?