topic Re: Clarity regarding Change Processing Tuning settings in Qlik Replicate

Clarity regarding Change Processing Tuning settings

MoeE — Mon, 15 Jan 2024 23:00:35 GMT

Hi,

I was reading through the Qlik Replicate Change Processing Tuning settings documentation and came across this message

I'm a bit confused as to whether this means that when both Apply changes using SQL MERGE and Optimize inserts are enabled simultaneously then Oracle and Salesforce are not supported as sources. Or does this mean that when EITHER setting is enabled i.e at least 1, then both sources are not supported?

Also, does this include logstream versions of the Oracle and Salesforce? For example if I have a downstream task going from an Oracle logstream source and not the original Oracle source endpoint.

Any help or clarification with this is going to be helpful. Thank you.

Kind regards,

Mohammed

Re: Clarity regarding Change Processing Tuning settings

DesmondWOO — Tue, 16 Jan 2024 04:24:47 GMT

Hi @MoeE ,

I think it means both "The Apply changes using SQL MERGE" and "Optimize inserts" are enabled. Also, "Optimize inserts" can be enabled only when the SQL MERGE is enabled.

In the latest user guide Nov2023, following statements are applied on the SalesForce:

As Salesforce does not generate a FULL after-image, the following limitation applies:
The INSERT the missing target record option and the Batch optimized apply mode of Apply
Changes using SQL MERGE option are not supported. If either of these options is selected, NULL
will be inserted into the target for all corresponding source columns that were not changed in
the UPDATE operation. If one of these columns is NOT NULL, the operation will result in an
error. If a table contains a LOB column, and the column was not changed, the task stops with a
fatal error.

If it means EITHER, above statement should be documented for the Oracle endpoint but above statement is removed from the latest user guide.

Regards,
Desmond

Re: Clarity regarding Change Processing Tuning settings

SushilKumar — Tue, 16 Jan 2024 09:09:18 GMT

Hello team,

If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer.

Regards,

Sushil Kumar

Re: Clarity regarding Change Processing Tuning settings

MoeE — Thu, 18 Jan 2024 04:38:48 GMT

Hi Desmond,

Thanks

Regards,

Mohammed