 |
MS SQL Server Fuzzy Matching
[reply]
|
07/16/07 06:54 AM EST posted by Blearns email web |
|
SQL Server 2005 Integration Services (SSIS) introduces two new tools designed for Data Warehousing, but their uses are far more than just warehousing. Fuzzy Lookups and Fuzzy Grouping can both improve quality of data. Fuzzy lookups is designed to correct errors in lookup tables such as misspelling in cities or states. Fuzzy grouping finds duplicates in datasets. [ Finding Similar Data Using SQL Server Integration Services ]
Fantastic article on a great new offering in MS SQL 2005 via SSIS. However I have need for this type of matching outside of SSIS. SSIS isn't easy to tie into a webpage for on demand matching of one item against a database, but that is exactly what I need. Anyone have any experience with this new fuzzy match?
|
|
[reply]
|
05/25/08 05:16 AM EST posted by jitendra email |
|
| Sql Server |
|
Note: Only registered ShinyDonkey.com users
can post images. Only administrators can delete images.