Does anyone know a good data cleansing tool(s)?

[tbtcust]

Hi all,

I have a customer database that needs straightening out. Then I need to moved the cleansed data to a warehouse. Does anyone know a good data cleansing tool(s) that will group like customers together so they can be review?

Thanks in advance for any help.

 

[ffoley]

We have used vality and trillium and of the 2 trillium is the product of choice. Data cleansing has many meanings to many people, these products are particullary good for name and address standardization and deduping. Some ETL tools now have cleansing tool functionality built in such as first logic routines in Informatica 7.x. If you are trying to determine if data follows specific rules, then there is another class of products which allow for some pretty elaborate data analysis .. might seem strange but SAS is very strong here but I think the tools are packaged with their warehouse solution.

hope that helps

hope that helps

 

[johnherman]

There are other cleansing tools. Quality Stage from Ascential, for instance.

See also this link

http://www.dmreview.com/portals/portal.cfm?topicId=230005

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[teccum]

Trillium is one of the tools which are quite popular among the I.T developers and Management. You can check that.

teccum.

 

[scorpionking27]

Firstlogic is another tool used for Data Cleansing and it has some other good features too. Also if you are existing Informatica customer, you will get this tool at lower price