Data Cleansing and Fuzzy Lookups with SQL Server Integration Services

Data quality is a critical issue for most web applications and databases.

For example, in an online bookstore "H.G. Wells" and "HG Wells" are the same author, but often duplicates like this in any database.

We have just finished a database cleansing solution for a client, and it has been interesting to use SQL Server's Fuzzy Lookup feature to achieve this.

If your interested in SQL Server Integration Services Fuzzy Lookup and Data Cleansing, check out this video (warning, is faitly technical)

Donald Farmer introduces the data quality features of SQL Server Integration Services with demos that show how to use the Fuzzy Lookup component for inexact matching and how to use Data Mining within the data integration process.

Watch Video at MSDN TV

Have your say!
Add a comment

1

Call Shifted Today on 02 8005 1568 At Shifted Pixels we go the extra mile to ensure that whatever work we do be it strategy, planning, design, development, online marketing, media buying yields a tangible net benefit. Give us a call, we would love to help your business grow online! See what shifted pixels has to offer

One Response to “Data Cleansing and Fuzzy Lookups with SQL Server Integration Services”

  1. Anonymous says:
    December 18, 2008 at 4:47 am

    link is broken

Leave a Reply

«
»