topic Re: Changing Primary Keys on Target in Qlik Replicate

Changing Primary Keys on Target

Dumma — Wed, 10 Aug 2022 15:29:15 GMT

i am changing my target primary keys on the transformation using this article as reference - https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/tasks_useTransTable.htm

However, i notice that in the target, the update went to an incorrect record. Are we allowed to change the PKs in the transformation.? What are the implications.?

Thanks,

Re: Changing Primary Keys on Target

OritA — Thu, 11 Aug 2022 06:52:05 GMT

Hi,

In general you can define a different key via trasformation rule as indicated in the documentation. However, you have to be aware of the consequences, as this, of course, may impact the unique key of the rows and may have impact during updates. If you would like further detailed investigation please raise a support case and provide the task diagnostic package with an example row so we can better undetstand the scenario.

Regards,

Orit