Qlik Replicate - Compress Table on Oracle as Target

[johannn]

Hello everyone,

we use Qlik Replicate to load data from an Oracle DB to an another Oracle DB (Source: Oracle, Target: Oracle) with "Apply Changes Processing" set to ON. In some cases there are large tables (on average about 500GB each).

Is it possible to make a compression on the target site as a configuration in the Qlik task? Can we make the compression afterwards on Oracle, will it affect the load in any way?

Does anyone have experience with it?

Thank you for your help.

Greets
Johann

[john_wang · Accepted solution]

Hello @johannn ,

Yes, it's supported. The compression in target side is transparent to Replicate - If the table is created before the Replicate task running, and you choose truncate the table (rather than drop/re-create it) while the target table exists (see screen copy below).

Regarding the source side compression, the detailed info can be found at Supported compression methods .

Hope this helps.

Regards,

John.

[johannn]

Hi John,

thank you for your reply. I will test immediatly.

Regards,

Johann