Reltio Connect

 View Only

  • 1.  Relationship Getting Merged

    Reltio Partner
    Posted 22 days ago

    Hi

     i am trying to load records with two relations

    src system ID Name address1 city state ogid istrue cdid refentity refrelation
    abc 1 xyzindustry ccc sss bbb 555 y 1 surrogate 111
    abc 1 xyzindustry ccc sss bbb 555 n 2 surrogate 222

    Yellow color record are relationship record attribute

    expected bheaviour is it should create one profile with two relations

    but it is now create one profile with one relation(two relations are getting merged)

    Can anyone help on this



    ------------------------------
    PRAVIN BIRADAR
    ------------------------------


  • 2.  RE: Relationship Getting Merged

    Reltio Employee
    Posted 21 days ago

    Hi Pravin, 

    Based on your input, It looks like the relationship in question is the OrganizationHasAddress Relationship. Can you please confirm if you are trying to load two Address relationships from the same Organization where all Address details are the same excluding the isTrue flag ? 

    Based on my speculation here is what might have happened: 

    • The key address fields configured in the Surrogate key configuration are exactly same for these two Address records. Hence Reltio created only one Location profile and created just one HasAddress relationshoip between the Organization and the Location. OR 

    • The Key address fields configured in the Location auto match rule are exactly same for these two records. That will also cause the two location profiles being merged. And as there is just one end object profile i.e. Location profile. You are seeing just one relationship. 


    Also, can you confirm if the IsTrue attribute is created under the relationship or under the Location entity type ? 



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------

    Original Message


  • 3.  RE: Relationship Getting Merged

    Reltio Partner
    Posted 21 days ago

    Hi,

    "IsTrue ","cdid" attribute is under the Relationship and cdid attribute value is different for 2 records.

    • The key address fields configured in the Surrogate key configuration are exactly same for these two Address records. Hence Reltio created only one Location profile and created just one HasAddress relationshoip between the Organization and the Location
      • Yes this what is configured

    But is their a way to create two relations instead of merging them ?



    ------------------------------
    PRAVIN BIRADAR
    ------------------------------

    Original Message


  • 4.  RE: Relationship Getting Merged

    Reltio Employee
    Posted 18 days ago

    Pravin, 

    Even though those relationship level attributes are different for the two address load. The actual address itself is the same i.e. It has created one single Location profile. So, in Reltio, when there is one single Start Object (Organization in this case) and one single End Object (Location in this case), only one relationship will be created between them even if there are more than one relationship crosswalk. 

    If you want to create more than one relationships, you might have to move one or more of those relationship attribute to the location profile and use under surrogate crosswalk configuration. So that more than one Location profiles are created. But that will not be advisable. Because the goal of Location entity with the surrogate crosswalk and the respective match rules are to ensure that only unique address records are created in Location entity and we can relate those to the Other entity types like Organization, Individual etc. 



    ------------------------------
    Diparnab Dey
    Technical Consultant
    Reltio
    Kolkata, West Bengal
    ------------------------------

    Original Message


Related Content