Reltio Connect

 View Only
  • 1.  Automatic Update in MDM based on the presence of Data in the incoming Json

    Posted 10-17-2024 06:34

    HI Team ,

    We have a requirement as below :-

    We have one nested attribute as Communication where we have attributes like Comm type ,value and Is Primary column .

    Now on first day data load for a particular entity we received three record in the nested as below :-

    Comm type   Value     Primary      Day  
    email 123@gmail        Y       Day1  
    email 789@gmail        N       Day1  
    email 456@gmail        N       Day1  

     

    On second day we received records of Communications  for the same entity as below :-

    Comm type   Value     Primary      Day  
    email 12345@gmail        Y       Day2  
    email 78966@gmail        N       Day2  
                 

    As you can see in second day the communication with value is not coming from source , rather than a new email has come as primary as old one has been replaced in the source system .So the requirement is any previous/old primary communication which is not coming from source in the input payload ,that has to be detected  inside MDM and need to be made non -primary.So after Day 2 data load ,the final result in Communication would be like below :-

    Comm type   Value     Primary      Day  
    email 123@gmail        N       Day1  
    email 789@gmail        N       Day1  
    email 456@gmail        N       Day1  
    email.         12345@gmail     Y              Day2  
    email 78966@gmail     N               Day2  
             

    Please let us know how to achieve this requirement in Reltio.



    ------------------------------
    Utsa Das
    Novartis
    ------------------------------


  • 2.  RE: Automatic Update in MDM based on the presence of Data in the incoming Json

    Reltio Employee
    Posted 10-18-2024 13:35

    Hi Utsa Das,

    Have the  inbound  to send all 5 emails with one Y or you can perform a custom calculation  like an LCA or a RIH recipe to writeback to the entity



    ------------------------------
    Kiran Ghanta
    ------------------------------



  • 3.  RE: Automatic Update in MDM based on the presence of Data in the incoming Json

    Posted 10-21-2024 03:23

    Can you please let me know how to do the calculation to make the old primary as non-primary while all 5 communications are coming in input for the second time load ?

    And I suppose for high amount of data ,there can be an impact on  the performance of the data load if we implement the logic in LCA .



    ------------------------------
    Utsa Das
    Novartis
    ------------------------------



  • 4.  RE: Automatic Update in MDM based on the presence of Data in the incoming Json

    Posted 10-22-2024 10:19

    Please let me know how we can make the primary communication inactive/non-primary which is no longer coming from source as source will never send the older primary communication as non-primary ,instead they will send new primary communication from their end.



    ------------------------------
    Utsa Das
    Novartis
    ------------------------------