1 Reply Latest reply on Nov 9, 2018 9:53 AM by Subbu K

    MDM - Match Merge Issue (Seems to be Transitive Match)

    Venkatesh Ramasamy New Member

      Hello,

       

      We have MDM for Customers and are running in to an issue. I see some records with the exact match rules does not match the first time. However, when I set the Consolidation_IND to 4 for the new record and run match the second time, I could see the records Match.

       

      For Example,

      ROWID_OBJECTCREATE DATECUSTOMER.FULL NAMECUSTOMER.TYPEADDRESS.Line 1ADDRESS.Line2ADDRESS.CITYADDRESS.COUNTRYADDRESS.STATEADDRESS.POSTAL CODE
      111/01/2018John DoeIndividual123 Main StreetLa VistaUSANE68128
      211/08/2018John DoeIndividual123 Main StreetLa VistaUSANE68128

       

      In the above table ROWID_OBJECT was a record that was created on 11/01. On 11/08, a new record with the exact same information was created, however, they did not match when the match job was run on these two records. Once I set CI=4 and re run match they match and merge in to one record.

       

      Has any one experienced this issue? This is causing duplicate data in MDM. Any advise would  be greatly appreciated.

       

      Version of MDM: 10.1.0 EBF2

       

      Match Rule:

      Auto: Yes

      Type: Fuzzy

      Accept Limit: 2

      Purpose Level: Resident(Typical)

      Match Columns:

           Address LIne 1& 2 - Fuzzy

           City

           Country

           Customer_Type

           Postal Code

           State

           Full Name (Fuzzy)

          

      Thanks,

      Venkatesh Ramasamy