Reltio Connect

 View Only
  • 1.  Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 20 days ago

    I have a question about survivorship rule configuration in Reltio MDM and would appreciate any recommendations or best practices.

    For our Contact Mastering implementation, we have two phases with different survivorship requirements:

    • Initial Load: We are loading contacts from six source systems to establish a complete view of each contact. During this phase, we want survivorship to be based on source system priority so that the initial golden records reflect the preferred values from each source.

    • Ongoing Incremental Loads: After the initial load is complete, only three of these source systems will provide daily updates. For these incoming updates, we want survivorship to be based on recency, so that the most recently updated attribute value takes precedence.

    We would like to transition from source system priority to recency-based survivorship after the initial load. However, we do not want the new survivorship configuration to recalculate or change the survivorship of existing golden records simply because the configuration has changed. The new strategy should apply as new source records and updates are processed going forward.

    What is the recommended approach for implementing this scenario in Reltio?



    ------------------------------
    Vera Bagboudarian
    Wilbur Ellis
    ------------------------------


  • 2.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 19 days ago

    Hi @Vera Bagboudarian,

    Yes, you can achieve the same using conditional survivorship which will depend on a flag or date field which will be populated only during incremental loads.

    So, if that field is not null or empty then you can set survivorship to run on Recency/LUD otherwise Source System



    ------------------------------
    Gaurav Mishra
    EPH Ops Technical SME
    ------------------------------



  • 3.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 19 days ago

    Thanks @Gaurav Mishra.
    Could you please clarify how conditional survivorship would be configured in Reltio?

    1. Is this achieved by setting up filter criteria within the survivorship rules, or is there another mechanism for configuring conditional survivorship based on a flag or date field?

    2. If filter criteria are used, does the flag or date field need to be defined as an attribute of the Contact entity in Reltio, or can it be a metadata or system-level field?

    3. Would the condition be evaluated each time an incoming record is processed, allowing us to use source system priority when the flag is empty and Recency/LUD when the flag is populated during incremental loads?

    We want to ensure that changing the survivorship strategy for incremental loads does not trigger recalculation of existing golden records simply because the configuration changes.

    Thanks again for your guidance!



    ------------------------------
    Vera Bagboudarian
    Wilbur Ellis
    ------------------------------



  • 4.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 16 days ago

    Please follow the instructions.

    Survivorship Rules | Reltio

    {
      "attribute": "configuration/entityTypes/<Entity>/attributes/<Attribute>",
      "survivorshipStrategy": "SRC_SYS",
      "sourcesUriOrder": [
        "configuration/sources/<HighestPriority>",
        "configuration/sources/<NextPriority>"
      ],
      "filter": {
        "uri": "configuration/entityTypes/<Entity>/attributes/initialDataLoad",
        "operator": "exists"
      }
    },
    {
      "attribute": "configuration/entityTypes/<Entity>/attributes/<Attribute>",
      "survivorshipStrategy": "LUD",
      "filter": {
        "uri": "configuration/entityTypes/<Entity>/attributes/initialDataLoad",
        "operator": "missing"
      }
    }



    ------------------------------
    Radhakrishnan Ramalingam
    Majix Solutions
    San Ramon, CA
    https://majixsolutions.com
    ------------------------------



  • 5.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 14 days ago

    Thank you! I will try this.



    ------------------------------
    Vera Bagboudarian
    Wilbur Ellis
    ------------------------------



  • 6.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 15 days ago

    Hello @Vera Bagboudarian,

    Please find below instructions -:(which are similar to what @Radhakrishnan Ramalingam has already mentioned -- THANKS :))

                             

    {
    "attribute": "configuration/entityTypes/Contact/attributes/MainAttribute",
                                "sourcesUriOrder": [
                                    "configuration/sources/Source1",
                                    "configuration/sources/Source2"
                                ],
                                "filter": {
                                        {
                                            "uri": "configuration/entityTypes/Contact/attributes/IncrementalLoadDate",
                                            "operator": "exists"
                                        }
                                },
                                "fallbackStrategies": [
                                    {
                                        "attribute": "configuration/entityTypes/Contact/attributes/MainAttribute",
                                        "survivorshipStrategy": "LUD"
                                    }
                                ],
                                "fallbackUsingCriteria": "ZERO_OR_MORE_THAN_ONE",
                                "survivorshipStrategy": "SRC_SYS"
                            },
                            {
    "attribute": "configuration/entityTypes/Contact/attributes/MainAttribute",
                                "filter": {
                                        {
                                            "uri": "configuration/entityTypes/Contact/attributes/IncrementalLoadDate",
                                            "operator": "missing"
                                        }
                                },
                                "survivorshipStrategy": "LUD"
                            },


    ------------------------------
    Gaurav Mishra
    EPH Ops Technical SME
    ------------------------------



  • 7.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 14 days ago

    Thank you!



    ------------------------------
    Vera Bagboudarian
    Wilbur Ellis
    ------------------------------



  • 8.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Reltio Employee
    Posted 15 days ago

    Hi,
    If I understood the requirement correctly, please let us know if this is possible - 

    • Keep the survivorship simple - LUD on the attributes ; Fallback on source system priority.

    During Initial load - 

    • Populate the crosswalk updateDate same for all sources that you are loading. If you are loading through the dataloader, then keep an updateDate column on the source file and map to crosswalk update date. Keep the date same for all records and all sources
    • If you are loading through the custom utility, then populate updateDate on the crosswalk section. Keep the date same for all records and all sources

    It should force the survivorship to use the fallback - which is source system.

    During ongoing loads - 

    • Populate the crosswalk updateDate as the actual update date (current date or could be update date from source)

    It should force the survivorship to use the top level strategy - which is Recency



    ------------------------------
    Ranadip Das
    ------------------------------



  • 9.  RE: Can Survivornship Rules be configured with Effective Dates to support different Initial and Incremental Load strategies?

    Posted 14 days ago

    Thank you! 

    Is the crosswalk updateDate a system attribute? Is it visible on the UI? 

    If we don't populate the crosswalk update date during the load, does the system automatically populate with the system date?



    ------------------------------
    Vera Bagboudarian
    Wilbur Ellis
    ------------------------------