Regarding the data compression settings for tables created independently by Qlik in Qlik Replicate/Qlik Compose

[iti-attunity-sup]

Hello team,

We are considering data compression using Oracle’s ‘ROW STORE COMPRESS ADVANCED’ for the following table.
- QlikReplicate：Change Tables "XXXX__ct"
- QlikCompose：Error mart table "XXXX__ex"
                           DWH table "TDWH_XXXX"

I believe there are no particular issues with Oracle’s constraints, but could there be any impacts other than on resources?
Also, will we be able to receive support if we use compression?

Best Regards

[kng]

Hello Team,

Good Day

Please refer the below link which provides the info regarding the supported compression method for the oracle source endpoint

Supported compression methods | Qlik Replicate Help

Regards,

Shivananda

[iti-attunity-sup]

Hello team,

I am considering compressing the following table created in Qlik. It is not a user table.
- QlikReplicate：Change Tables "XXXX__ct"
- QlikCompose：Error mart table "XXXX__ex"
DWH table "TDWH_XXXX"

Are there any limitations? Is support available?

[sureshkumar · Accepted solution]

Hello @iti-attunity-sup 

As per my understanding, you want to apply compression mechanism in Oracle DB where the Compose tables are present.
You want to know the impact of it, i.e. Compose ETL jobs etc. Also if you apply and there is an issue and also we give support or not.

If this is your scenario then I'm not sure of it and i need to check with our internal team. Could you please open a support team with us.

Regards,

Suresh