Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Data Quality: Standardize Global Phone Numbers

Free download

Posted by: Informatica

An Informatica Data Quality mapping that demonstrates how to standardize global phone numbers.


The conventions for writing, telephone numbers vary by country. It is an open numbering plan, however, imposing a maximum length of 15 digits to telephone numbers. The standard defines a country calling code (country code) for each region which is prefixed to each national numbering plan telephone number for international destination routing.


The source has phone number data belongs different countries in different formats. With the help of Informatica Data Quality rules the phone numbers are standardized into (+Country code) -***-***-***** this format.


Solution :


This mapping helps to standardize all countries phone number into a common format. The Lookup has country calling code of all countries. By using Data Quality rules,. Based on the length of the country code, match the country code with phone number. If the country code matches, then standardize the phone number otherwise append the country code to the phone number and standardize the phone number.

Key Features

Informatica Developer Client 9.5.1 and above.


  • Informatica Developer Client 9.5.1 and above.


global.comments global.comments (9)