Learn about consolidating relationship crosswalk to prevent excessive entries.

Do you have an excessive number of crosswalk entries in your relationships or are you looking to prevent that? Use this consolidation mechanism to ensure cleaner, more efficient relationship management by detecting and consolidating redundant crosswalks. The mechanism is especially useful for relationships like "HasAddress," where minor variations in data can create unnecessary duplicates.

Here's how it works:

• Detection: The system consolidates crosswalks when they share:
  • The same relationship type (for example, HasAddress).
  • The same start and end objects contributor.
• Example: If a HasAddress relationship includes redundant entries from the same source, enabling the consolidation flag ensures that only the latest, most accurate entry is kept.

{
...
...
...
 "enableNestedPartialOverride": true,  
  "enableReferencePartialOverride": true, "contributorCrosswalkSingleSourceUpdateMode" : true,
...
...
}

"relationTypes": [
        {
            "uri": "configuration/relationTypes/HasAddress",
            "contributorCrosswalkSingleSourceUpdateMode" : false,
            "attributes": [
                {
....
...
}
]
}

Once you change the configuration with the flags, then run the Relations Start End Objects Consistency Check Task with parameter consolidateRelationCrosswalk.