Reltio Connect

 View Only
  • 1.  Optimised way to Update Nested Attribute

    Posted 22 days ago

    Hi Team,

    Posting this message to know the optimised approach to perform operation on Nested attributes.

    I have an entity where we load the data through dataloader which has "Entity + Address" Information and the Refentity value is "SURROGATE". In the file i have 8 nested attributes such as (Email, Phone, Url, etc.,). For me to load a record and have all the nested attributes updating i am using Full Update which in turn every time is deleting and creating relationships again for Address entity.

    For me to switch from Full Update to Partial Update, i am thinking of a solution that takes care of Nested attribute handling so that the no.of eevnts which is getting triggered to Address entity will get reduced.

     Example

    Yesterday a record had full information of a person with 4 emails, 5 phones + Address = Full Update -> All information is flown + Multiple events are triggered to Address entity such as Relationship Created and Updated even though there is not change in Address

    Today, again same record comes in with 3 emails, 1 phone number + Address (No Update) -> All the nested attributes are updated by removing un-necessary ones + Multiple events are triggered to Address entity such as Relationship Created and Updated eventhough there is not change in Address

    Need - If i have a way to handle the nested attributes updates -> i can switch to Partial Update and decrease no.of events that are getting triggered

    Any thoughts Experts?



    ------------------------------
    Chetan
    ------------------------------


  • 2.  RE: Optimised way to Update Nested Attribute

    Reltio Employee
    Posted 22 days ago

    Hi Chetan,

    Please try switching to partial override for nested attributes, and do not pass the address reference attribute in the payload unless address is updated



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Staff Forward Deployed Engineer
    Reltio
    Bangalore
    ------------------------------



  • 3.  RE: Optimised way to Update Nested Attribute

    Posted 22 days ago

    Hello, Need a small clarification.

    Do you mean - Do the Dataload with Partial Update with Partial Override for nested attributes option @Snehil Kamal



    ------------------------------
    Chetan P
    Lead MDM Specialist
    Freshworks
    Chennai
    ------------------------------



  • 4.  RE: Optimised way to Update Nested Attribute

    Reltio Employee
    Posted 22 days ago

    That's right Chetan



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Staff Forward Deployed Engineer
    Reltio
    Bangalore
    ------------------------------



  • 5.  RE: Optimised way to Update Nested Attribute

    Posted 22 days ago

    In That case @Snehil Kamal , For below example using partial update with partialoverride for nestedattributes - 

    Yesterday a record had full information of a person with 4 emails, 5 phones + Address

    Today, again same record comes in with 3 emails, 1 phone number + Address 

    Question - Does it remove that 1 email, 4 phone numbers that were not present in today's file when i load it with the above-mentioned property?



    ------------------------------
    Chetan 
    ------------------------------



  • 6.  RE: Optimised way to Update Nested Attribute

    Reltio Employee
    Posted 22 days ago

    It will not remove, it will append/update the nested attribute values from the request payload to the existing object



    ------------------------------
    Thanks,
    Snehil Kamal
    Senior Staff Forward Deployed Engineer
    Reltio
    Bangalore
    ------------------------------



  • 7.  RE: Optimised way to Update Nested Attribute

    Reltio Employee
    Posted 22 days ago
    Yes, for sure that be the result.  With a partial update, if there is no change to the data, Reltio will automatically do the delta recognition to understand that and no update will be put on the queue.  With a full update, you are defining that you ARE updating the data, so an event will be generated.


    Gino Fortunato
    Principal Solutions Consultant
    gino.fortunato@reltio.com
    (855) 360-3282