Merge/Purge

Greetings,

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,
Gerry Thorpe Received on Mon Sep 27 1999 - 00:00:00 CEST