As a Senior Technical Consultant, I get asked a lot of the same questions over and over. In this blog, of two, I will focus on FAQ’s around Matching Rules.
Survivorship and Match Rules are tightly coupled in terms of their actual use, but for this blog post, I will focus on Match Rules and return to survivorship later. Let us start with some easy questions about how they are implemented.Q: Are Match Rules created through the UI or in the L3 config?
Q: If an update comes through for a particular crosswalk on an existing party profile, and that crosswalk updates the Golden Record in such a way that it now matches with another party profile, does that get done dynamically now in Reltio? Say the source system accidentally entered the wrong date of birth, we come through with an update and the date of birth updated, will that trigger another match?
A: Yes, that will happen in milliseconds if it triggers an automatic match rule unless there is a big queue. If this is a realistic concern you make the rule a potential match rule. This suggests matches, but does not merge them without human intervention. You can also turn off incremental matching if you do not want any records matching in real time.
Analyze Match Rule
Before we look at the dig into specific match rules, I recommend taking a look at the analyze match rules tool. It is great for identifying how efficient your Match Rules are. It takes a little bit of the art out but allows you to be a little more scientific in identifying where your Match Rules overlap. If two rules are generating 95 percent of the same results, there is probably not much value in having two rules with similar outcomes.
Q: How do I tell the effectiveness of my Match Rules based on this?
A: The results of this analysis are color coded, visually showing the outcomes, along with comments on how the rules might be improved to the right. You can find the analyze match rules tool in the data modeler, under match rules in the top right corner. It will generate a report showing which rules are good (in green), which rules have large overlap (in yellow) and which rules have problems (in blue).
The Data Modeler is also where you make Match Rule changes. Pick one of your entity types, and in the header navigate to Match Rules. You can see a list of all your existing Rules. After making changes to a rule, it is best practice to rebuild the match tables. This is available in the console under Tenant Management > Jobs > Rebuild Match Table. The job recreates the tokens used to match records to one another.
Q: If you forget to rebuild, what happens?
A: Your existing data may not match on your modified rule as you might expect. As new records are loaded they will have tokens generated against your modified rule, but be compared to the old tokens of records loaded before the rule changed.
Internal and External Matching
In Reltio, there are two types of matching: internal and external. Let’s assume you wanted to bring on a new source. You want to see how the new records will integrate with your tenant, but don’t want to experience the potentially painful process of unmerging them. External match allows you to upload a file through an API and match your tenant data to the file data. It’s nice to see how a new source will play out before you actually load it.
Internal matching is the process of comparing and merging entities already loaded to Relto. There are currently two types (and soon to be a third type) available: Suspect, cued up for a data steward to review via a workflow; Automatic, records automatically merged and Relation, (coming soon) which creates a relationship between records rather than merging.
Q: If there was a potential match, and an update to a birthdate made the match rule no longer true, will the potential match go away?
A: They will no longer be potential matches and it will remove them from the potential match workflow. If they have already been merged and an update comes through to one of the crosswalks, they will stay merged. We will not unmerge for you. It is a pretty important distinction. There is nothing at this time that monitors and unmerges records.
Assemble Park City1389 Center Road, Unit 200Park City, Utah 84098USA
+1 (855) 360-DATA+1 (855) 360-3282
© 2022 Reltio. All Rights Reserved
Site by eConverse Media