Re: Opinions on ListCleaner ( WinPure ) ??

[EMAIL PROTECTED] (dbdb) wrote in 
news:[EMAIL PROTECTED]:

> Anyone here tried ListCleaner by a company called WinPure
> http://www.winpure.co.uk/lists  (a data deduping software) in
> comparison to other products that may be out there?  Looks like some
> companies like Hewlett Packard use this.
> 
> I am looking for a good (and inexpensive) datacleansing tool to dedupe
> and standardise lists, happy to extract the data from database and
> re-import it (which seems WinPure does) before incorporating it into
> other BI tools.  Tried MatchIt from help it systems but it is a bit
> cumbersome.
> 
> Particularly interested in a tool with a good phonetic matching
> engine, that handles multiple lists.
> 
> Mostly work with oracle, sql and access. 
> Recommendations appreciatated.

Every report I have heard on this indicated that it was a disaster. It 
failed to find similarities that existed and found similarities that did 
not exist;; some input tables were corrupted after exposure to this tool.

I strongly recommend hiring a database professional to develop a custom 
import/cleanup application for your needs.

Hope this helps!

-- 
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)