| |
| ||||||
Fuzzy ThinkingThis is a discussion on Fuzzy Thinking within the BI Monkey forums, part of the CORTEX Blogs category; I’ve covered off the Fuzzy Lookup and Fuzzy Grouping transformations in SSIS and noticed in my research that these capabilities aren’t particularly coherently talked about on the web. So below ... |
![]() |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
| | #1 |
| Guru Join Date: Jun 2009
Posts: 122
![]() | I’ve covered off the Fuzzy Lookup and Fuzzy Grouping transformations in SSIS and noticed in my research that these capabilities aren’t particularly coherently talked about on the web. So below I thought i’d collect some of the better articles for your late night reading. There isn’t all that much out there, unfortunately. So, how does it all work? Here are a few articles covering theory, mostly from Microsoft:
Ok, so how do I make it work? Now, some articles covering practical implementation of the tasks:
And what does the BI Monkey have to say about it? Fuzzy Matching is a powerful and easy to use tool which is great for approximate grouping of data for analysis where a margin of error is tolerable. It is also a great helper in data cleansing exercises. Having too much faith in the results where exact matches are required will cause you to fall over at some point, so be careful. If you are engaged in such an exercise and want some experienced support, please get in touch. And in other news, fresh from Jamie Thompson – Fuzzy Lookup and Regex are going to become available in SQL2008R2. If you have come across any articles that you think really contribute something to the understanding of fuzzy matching technologies in SQL Server / SSIS, please let me know or post a link in the comments so I can improve this article. Get More from the original blog... |
| | |
![]() |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| The Fuzzy Grouping Transformation | James Beresford | BI Monkey | 0 | 5th November 2009 08:00 PM |
| Short-term rates thinking at Westpac | Latest News Headlines | 2009 Q4 News Headlines | 0 | 4th November 2009 08:10 AM |
| The Fuzzy Lookup Transformation | James Beresford | BI Monkey | 0 | 23rd June 2009 09:34 PM |
| Start thinking about lodging your 2007-08 tax return now | binboy | Jobs Wanted | 0 | 15th July 2008 10:40 AM |
| | |
| | |