Overview of Customer MDM
Customer MDM is the process of consolidating customer information from different sources and creating a unified Customer Master that does not have duplicate records. It also offers capability for ongoing maintenance of customer data and deployment to downstream systems.
Assume the scenario where the customer information is as follows:
Field | Value |
Business Name | Software AG |
Address Line 1 | 433 Hackensck Av |
Address Line 2 | Hackensack, NJ |
Phone Number | (201) 4895600 |
The data quality server, for example, Trillium, returns the following output after cleansing and validating the input values.
Field | Cleanse/Standardize Step | Address Validation Step |
Cleansed Business Name | Software AG | |
Cleansed Phone Number | 1-201-489-5600 | |
Street | | Hackensack Ave. |
City | | Hackensack |
State | | NJ |
Building Number | | 433 |
Postal Code | | 07601-1699 |