Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: slightly OT - cleaning up "dirty" keys?
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