Swapping Master Record to Golden Record (Swap PUBID & SOURCE ID from MD to GD Table)
S
Subramani SIVARATHNAM
started a topic
about 1 month ago
How to swap Master Record PUBID & SOURCE IDto Golden Record (Swap PUBID & SOURCE ID from MD to GD Table)
Best Answer
A
Alexia SIMOND
said
22 days ago
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.
So you may need to review it to prioritize ZOOM publisher or however best suits your business requirement.
Best regards,
Alexia
S
Subramani SIVARATHNAM
said
23 days ago
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)
S
Subramani SIVARATHNAM
said
22 days ago
I am looking for the process thru Backend using UM or SD Table.
A
Alexia SIMOND
said
22 days ago
Answer
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.
Subramani SIVARATHNAM
How to swap Master Record PUBID & SOURCE ID to Golden Record (Swap PUBID & SOURCE ID from MD to GD 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
- Oldest First
- Popular
- Newest First
Sorted by PopularSubramani SIVARATHNAM
Any Update: Details in the PPT
Subramani SIVARATHNAM
Your help is appreciated
Alexia SIMOND
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
Subramani SIVARATHNAM
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)
Subramani SIVARATHNAM
I am looking for the process thru Backend using UM or SD Table.
Alexia SIMOND
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
-
Can we reset Matches and run again on match rule change or add a new match rule?
-
"Unmerge" records
-
Turn off match rules to speed up an integration job
-
Can anyone tell me how to load a Fuzzy-Matched entity ... but skip the matching happening auto-magically?
-
Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
-
How can I trigger a "match on child records"?
-
How can I Configure Most Frequent Values in Survivorship Rules?
-
Deterministic or probabilistic matching
-
Machine Learning and AI for matching
-
Prevent loads from replacing values overridden by users
See all 53 topics