Find Duplicate - Based on different criteria
Requirement is find the duplicates based on 3 different criteria -
- Name and Phone Match
- Name and Email Match
- Name , Address Match
Now how to achieve this, should I use 3 Different Find Duplicates in Parallel and then check Match Status any 1 of them 0? Is it possible to check in one Find Duplicate?
I think we can include scoring facilities in Aperture so that even if Name, and Phone Match it gives a Scoring value based on the Algorithm. Scoring will be less for very common names in USA ex. John, Harry whereas scoring will be more if the Name is uncommon ex. Mahulima in USA
Also Robert and Bob will match Mathew and Matt will match this scenarios may be covered.
Also household cases will be covered with low weight age in Address
And in this method for my use case I will be giving weight-age to Name, Phone, Email and Address and will give a combine score for 2 records which are suspected a match. And may be I can define threshold scoring coming 8-10 is suspected, below 8 is not match, over 10 is MATCH