Exect difference between Fuzzy lookup and Fuzzy grouping

Question

Hi all,

   Can you pls explain difference between Fuzzy lookup and Fuzzy grouping in simple word,pls

Thanks

Selva

Answer 1

Good explanaition :

http://stackoverflow.com/questions/1894593/question-on-fuzzy-logic-fuzzy-grouping-fuzzy-fuzzy-lookup-transformation-in

For more détails :

http://technet.microsoft.com/en-us/library/ms345128(v=sql.90).aspx

Answer 2

Hi Selva,

In brief, the Fuzzy Grouping Transformation can be used to group the similar rows in the source dataset and identify rows of data that are likely to be duplicate; while the Fuzzy Lookup Transformation can match records between the source table and reference table that are similar, but not identical to, the lookup key.

Here are good examples about the two transformations:

• http://ssis-tutorial-online.blogspot.com/2013/04/fuzzy-grouping-transformation.html 
• http://www.codeproject.com/Tips/528243/SSIS-Fuzzy-lookup-for-cleaning-dirty-data 

Regards,

---

Mike Yin
TechNet Community Support