I am looking for information about and software to do Merge/Purge.
Merge/Purge is a solution to the problem of multiple data sources
that need to be consolidated. The problem is that the consolidation
of data can not be done with a simple database join across tables.
A typical situation is as follows: John Doe, may be in one
data source as John Doe, another as Jonny Doe, another
as J. Doe, Johnathan Doe, etc. I would like to be able to
take the data from all of those sources and construct a single
row of data that aggregates the data from all those rows.
What I need is a system that knows that John Doe, Jonny Doe,
J. Doe and Johnathan Doe are all likely the same person.
Any leads would be appreciated.
Thanks in advance,