Reltio Connect

We are implementing MDM for our customer domain, we've got data quality issues in customer Phone Numbers.

Phone Number Data Quality Issues 
1.  Numbers without country code
2. Numbers with additional characters (e.g. '-','+','.','(',')')
3. Incomplete Numbers
4. Numbers with wrong country codes

Reltio phone cleansing operation by default considers every number as USA number unless country code is specified, and does not lookup with city/state/country to establish the validity.  Above second issue is handled in our source to MDM integration process but others still exist. It would be great to know how bad phone numbers are being handled, Standardised, and enriched  and best practices around in MDM.

Hi Rupam,

1.  Because country dialing code is unambiguous, if the country is known it can easily be looked up. I have fixed this case outside of Reltio with simple match country code (i.e. iso-3166) to the dialing code outside of Reltio. Then load the values into Reltio via Data Loader. Or do you mean the iso-3166 is missing?
2. From my experience, it is best to strip all of this punctuation. It tends to be used irregularly, and that only leads to more problems. 
3. If the phone number is "incomplete", i.e. it is 9 digit, but country is US, so you expect 10 - this is a problem best solved with input validation. Reltio would never know what digit to add in.
4. Same process to correct the dialing code as to fill in missing. Or do you mean the iso-3166 is wrong?

Regards,
Walt