Re: Deduplication of records
Date: Tue, 01 Jan 2002 08:12:24 GMT
Message-ID: <IbeY7.263$gO5.181648_at_news1.news.adelphia.net>
You use an attribute of person that is guaranteed to be unique as the primary key.
For instance, here in the US, the Social Security Number is almost invariably used as primary key for person tables.
Alex Pilling FIAP MISM AIDPM
Business Systems Architect
alex_at_tabbybadger.com
"Raymond de Ligt" <rdl_at_dss.nl> wrote in message
news:Xns911BB06EEA9AArdldssnl_at_213.222.27.9...
>
> Hi Everybodu, does anyone have some information about how to deduplicate
> records in databases, example how does one prevent that he gets the same
> person Mr. Johnson more than once in the system , once as Mr. Johnson and
> the other time as Mr. Johnsson.
>
> I'm doing this on a Magic system and a oracle Dbase
Received on Tue Jan 01 2002 - 09:12:24 CET