topic Re: Configuring CDC with Append Load Type in Qlik Replicate

Configuring CDC with Append Load Type

RV101 — Tue, 08 Apr 2025 07:13:50 GMT

Hi,

I have a Full Load and Change Processing CDC task setup between my MS-Sql Server and Google BigQuery. However, I wish to configure my CDC job such that change data is appended to the Full Load. This is as I wish to maintain historical data. I want new records (updates, inserts etc) to be added in my target, without altering the existing records.

Any guidance on how I may set this up would be greatly appreciated.

Re: Configuring CDC with Append Load Type

john_wang — Tue, 08 Apr 2025 07:52:39 GMT

Hello @RV101 ,

Thanks for reaching out to Qlik Community!

Yes, it's easy to archieve that, please have a look at the function operation_indicator.

Feel free to let us know your results.

thanks,

John.

Re: Configuring CDC with Append Load Type

RV101 — Tue, 08 Apr 2025 08:20:06 GMT

Hey John, @john_wang

Thanks for the reply.

I am not sure where the operation indicator expression will be able to help.

I wish to ensure that any updates and insertions into my data as a part of cdc will be populated as new rows of data that are added into my target.

For example.

I have provided the image below as to how I wish to handle my changes.

Re: Configuring CDC with Append Load Type

Heinvandenheuvel — Tue, 08 Apr 2025 14:01:21 GMT

Seems to me you want to use the "Store Changes" option in CDC.

Google for "Qlik Replicate Storing changes in Change Tables"

Hein.