Start a new topic

Swapping Master Record to Golden Record (Swap PUBID & SOURCE ID from MD to GD Table)

How to swap  Master Record PUBID & SOURCE ID  to Golden Record (Swap PUBID & SOURCE ID from MD to GD Table)


Any Update: Details in the PPT

Your help is appreciated

pptx

Hello Subramani,


There is no way to swap per se the pubid and sourceid in golden record post integration.


Because this is directly handled by the certification process itself. It is known as the IdSurvivorshipRule:


Here is the documentation link explaining how it is working:

https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/Design/matching/survivorship.html#_master_id_survivorship_rule


So you may need to review it to prioritize ZOOM publisher or however best suits your business requirement.


Best regards,

Alexia

Hi Alexia, The Ask is, 
In the MD Table, we have multiple SORUCE ID, for 1 GD record.
I want to have 1 Particular Source ID move to GD Record (but we want to keep all the Source record in the MD table)

I am looking for the process thru Backend using UM or SD Table.

Hello Subramani,


As mentioned, it is not possible to do so outside of the certification process.


You can configure the master ID survivorship rule to your leisure to match your requirement, but if the need is to reprocess the golden SourceID after the certification took place, it is not possible through SQL.


The only supported SQL scripts to manage duplicates are available in our documentation.

And as you'll see, it does not contain such process.


However, if you update the master ID survivorship rule and replay the records involved, it should do the trick.


BR,

Alexia

Login to post a comment