Is there a simple way to look up a parent table during enrichment to find the best value based on a text attribute of the record being enriched using SemQL? Ex: countryName, FID_Country. I want to look up the country entity for the best match using Sem_edit_distance between countryName and Country.Name and set the FID_Country accordingly. Is the lookup enricher the way to go?
Best Answer
F
Fathia Jama
said
over 2 years ago
Unfortunately, the current lookup enricher is not the right way to do that because it works only with exact matching lookup natively. The lookup table is loaded in memory and the enricher looks an exact value into this table. For information, we have a story to enhance enrichment with fuzzy lookup capabilities (MDM-10482) but it's still WIP.
So to achieve your use case, you need to manage a custom SQL lookup function using the database native fuzzy features (like UTL_MATCH.EDIT_DISTANCE_SIMILARITY on Oracle) and call this function into a semql enricher.
1 Comment
F
Fathia Jama
said
over 2 years ago
Answer
Unfortunately, the current lookup enricher is not the right way to do that because it works only with exact matching lookup natively. The lookup table is loaded in memory and the enricher looks an exact value into this table. For information, we have a story to enhance enrichment with fuzzy lookup capabilities (MDM-10482) but it's still WIP.
So to achieve your use case, you need to manage a custom SQL lookup function using the database native fuzzy features (like UTL_MATCH.EDIT_DISTANCE_SIMILARITY on Oracle) and call this function into a semql enricher.
Fathia Jama
Is there a simple way to look up a parent table during enrichment to find the best value based on a text attribute of the record being enriched using SemQL? Ex: countryName, FID_Country. I want to look up the country entity for the best match using Sem_edit_distance between countryName and Country.Name and set the FID_Country accordingly. Is the lookup enricher the way to go?
Unfortunately, the current lookup enricher is not the right way to do that because it works only with exact matching lookup natively. The lookup table is loaded in memory and the enricher looks an exact value into this table. For information, we have a story to enhance enrichment with fuzzy lookup capabilities (MDM-10482) but it's still WIP.
So to achieve your use case, you need to manage a custom SQL lookup function using the database native fuzzy features (like UTL_MATCH.EDIT_DISTANCE_SIMILARITY on Oracle) and call this function into a semql enricher.
Fathia Jama
Unfortunately, the current lookup enricher is not the right way to do that because it works only with exact matching lookup natively. The lookup table is loaded in memory and the enricher looks an exact value into this table. For information, we have a story to enhance enrichment with fuzzy lookup capabilities (MDM-10482) but it's still WIP.
So to achieve your use case, you need to manage a custom SQL lookup function using the database native fuzzy features (like UTL_MATCH.EDIT_DISTANCE_SIMILARITY on Oracle) and call this function into a semql enricher.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 274 topics