Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: slightly OT - cleaning up "dirty" keys?

Re: slightly OT - cleaning up "dirty" keys?

From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Fri, 03 Mar 2006 16:20:14 +0000
Message-ID: <44086cbe$0$70293$ed2619ec@ptn-nntp-reader03.plus.net>


EdStevens wrote:
> And that means looking at the human factors as well. Not knowing anything about
> the application, I'm wonder WHY the operators are failing to find an
> existing record and end up createing a duplicate.

There's an automatic feed from external sources, which include all the "secondary" data (address, phone etc).

If the (primary)name doesn't match, a new record is created, from all the fields in the external feed.

Combine this with multiple external sources, run for 5 years, and you have a mess.

That's where I'm STARTING.

Now I have to "make it better".

    BugBear Received on Fri Mar 03 2006 - 10:20:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US