Importing CSV in Fuzzy Matched Entity Does Not Trigger Consolidation
F
Fathia Jama
started a topic
over 2 years ago
I tried to create a basic Fuzzy Matched Entity. After creating Matcher (Record1.FirstName = Record2.FirstName) and Survivorship rules (custom ranking) when I import data into reference data (CSV file snip attached below ) in Golden Records no consolidation happened based on FirstName (all the records appearing as same as input file) and there are no records in Master Records. I what to know the steps what I'm missing/doing wrong and how publisher ID's are updated in Master records and what are Golden type field (Eg : DE_BASED , MASTER_BASED etc. )
Best Answer
F
Fathia Jama
said
over 2 years ago
The authoring action that you're using to import the csv is, by default, set to Golden Records. Therefore the records are DE_BASEDso won't go through matching or consolidation. To be able to match data, the records need to be Master Records.
In order to set up the authoring action to import Master Records, you need to configure this in the Action Set:
The 'Imported Record Type' is set to Master Records.
You then need to set up a Business View with a 'View Type' of Master Data, so that you can use the Import action:
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
The authoring action that you're using to import the csv is, by default, set to Golden Records. Therefore the records are DE_BASEDso won't go through matching or consolidation. To be able to match data, the records need to be Master Records.
In order to set up the authoring action to import Master Records, you need to configure this in the Action Set:
The 'Imported Record Type' is set to Master Records.
You then need to set up a Business View with a 'View Type' of Master Data, so that you can use the Import action:
Fathia Jama
I tried to create a basic Fuzzy Matched Entity. After creating Matcher (Record1.FirstName = Record2.FirstName) and Survivorship rules (custom ranking) when I import data into reference data (CSV file snip attached below ) in Golden Records no consolidation happened based on FirstName (all the records appearing as same as input file) and there are no records in Master Records. I what to know the steps what I'm missing/doing wrong and how publisher ID's are updated in Master records and what are Golden type field (Eg : DE_BASED , MASTER_BASED etc. )
The authoring action that you're using to import the csv is, by default, set to Golden Records. Therefore the records are DE_BASED so won't go through matching or consolidation. To be able to match data, the records need to be Master Records.
In order to set up the authoring action to import Master Records, you need to configure this in the Action Set:
The 'Imported Record Type' is set to Master Records.
You then need to set up a Business View with a 'View Type' of Master Data, so that you can use the Import action:
Fathia Jama
The authoring action that you're using to import the csv is, by default, set to Golden Records. Therefore the records are DE_BASED so won't go through matching or consolidation. To be able to match data, the records need to be Master Records.
In order to set up the authoring action to import Master Records, you need to configure this in the Action Set:
The 'Imported Record Type' is set to Master Records.
You then need to set up a Business View with a 'View Type' of Master Data, so that you can use the Import action:
-
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?
-
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 44 topics