Is there a way to get the entities that has certain number of reference crosswalk?
currently the limit is
maxReferenceCrosswalksPerEntity - 2000
I want to get a report from reltio or a api to check if there are entities at risk to hit this limit, say the crosswalk count is more than 1800.
Any guidance on this subject would be helpful.
To the best of my knowledge, there is no single API that you can use to get this information. But there are a couple of ways to can get the list of entities that might be at risk of crossing this threshold.
Let's work with an example here. Let's say you have Individual records with Address as a reference attribute (referenced from Location entity) and Account as a reference attribute (Referenced from the Account entity ).The objective is to find the list of Individuals that might have close to 2,000 referenced crosswalks. Here is how I would do it
You can now try different filters using the data from the referenced entities that we know have a large number of crosswalks which will be pulled into the referenced entity
In short, what I am suggesting here is to get the list of referenced entities that have a large number of crosswalks and then try to see which Individuals these entities are referenced in. This may not be the perfect solution to get the accurate list but something that you can follow to get a candidate list that potentially will have a large number of crosswalks because of the referenced entity
Of course, there is a more reliable way to get the accurate count by writing some sort of script using python, Java, etc to count the crosswalks of refEntities and refRelations.
Please let me know if you have any follow up questions on this.
In my data scenario, HCP is referring to 3 relationship to fetch the attributes. And these 3 relationship is using 2 entities, HCO and location.
There are 300+ relationship for this HCP profiles distributed among these 3 relationship.
If i check individually at entity level HCO and Location, there are no such profiles which exceeds 150 + crosswalk.
But the combined crosswalk from the 300+ relations for this HCP profile is 2033. where as the limit is 2000 and the load fails.
100 Marine Pkwy #275, Redwood City, CA 94065
+1 (855) 360-DATA+1 (855) 360-3282
© 2022 Reltio. All Rights Reserved
Site by eConverse MediaAlso of Interest: Master Data Management (MDM) Reltio Community Reltio Integration Hub Community, Data Management Community Matching, Merge, Survivorship Reltio Workflow Master Data Management (MDM)