topic how deleted records are processed by Qlik Replicate ? in Qlik Replicate

how deleted records are processed by Qlik Replicate ?

deaconescu — Wed, 03 May 2023 11:08:03 GMT

Hello all ,

Can anyone tell , how the deleted records are processed by Qlik Replicate ?

Thank you

Ionut D.

Re: how deleted records are processed by Qlik Replicate ?

Pedro_Lopez — Wed, 03 May 2023 13:03:56 GMT

Hi Ionut,

Thanks for reaching out. Could you please elaborate more on what do you mean by "deleted records are processed by Qlik Replicate"?

Is there something specific you'd like to know? As a rule of thumb if the settings are as default, Replicate will read the records that were Deleted on the Source and apply the DELETE event in the target as well. Please note that a table with Primary Key is crucial in these scenarios, as the lack of it might impact negatively performance.

Regards,
Pedro

Re: how deleted records are processed by Qlik Replicate ?

deaconescu — Thu, 04 May 2023 10:42:53 GMT

Hi Pedro ,

And thank you for your response .

It was a general question from customer , they wanted to know if Qlik has any impact on deleted records .

However, from you reply , should I understand that if the table don't have the Primary Key it will lead in discrepancies between source and target ?

Thank you

Ionut D.

Re: how deleted records are processed by Qlik Replicate ?

Steve_Nguyen — Thu, 04 May 2023 12:33:36 GMT

@deaconescu

1. first look at the user guide :

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Introduction/Home.htm

2. look at what is your source and target endpoint and check to see any limitation.

Re: how deleted records are processed by Qlik Replicate ?

Dana_Baldwin — Thu, 04 May 2023 14:53:23 GMT

Hi @deaconescu

I believe @Pedro_Lopez 's comment on a PK being defined on the table relates to the performance of the task. Without a PK defined on the target table in a traditional relational database, a full table scan has to happen on the target database in order to delete the rows, which takes more CPU/memory on the target than it would if a PK were available.

Thanks,

Dana