Changing Primary Keys on Target

[Dumma]

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/Custom...

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,

[OritA · Accepted solution]

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