Matching for Management: Matching Examples  Let’s take a look at
some typical customer records that we’re about to bring into a
master data management system. In table 1 you see a couple of
customer records from different systems.  Table 1 – Customer
Data  As you can see there are different variations of the
customer’s name. Also if we look at the address you can see
again variations of the way the address is recorded in the
record. In some instances the building number is expressed as a
digit while in others it is expressed as a word. Also in one
record the entire address is in one field while in others it is
broken out by city, state and zip as well as a street address.
We can also see that the phone number field is in different
formats and missing in two records. You will notice that in some
instances the date of birth is not there as well as the gender.
Normally I would clean up this data before I would attempt to do
any matching. However just to show how powerful Informatica
matching capabilities are, I