Configuring CDC with Append Load Type

[RV101]

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. 

[john_wang]

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.

[RV101]

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.

[Heinvandenheuvel]

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

Google for "Qlik Replicate Storing changes in Change Tables"

Hein.