topic Replicate - Oracle Clob to SQL Server in Qlik Replicate

Replicate - Oracle Clob to SQL Server

MichaelWee — Wed, 03 Nov 2021 22:25:57 GMT

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!

Re: Replicate - Oracle Clob to SQL Server

john_wang — Thu, 04 Nov 2021 12:46:25 GMT

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.

Re: Replicate - Oracle Clob to SQL Server

MichaelWee — Thu, 04 Nov 2021 20:26:10 GMT

Thank you. Any observations on Incremental load?