Question: what is the difference between fuzzy lookup and fuzzy grouping?
Answer: Differences Between Fuzzy Lookup and Fuzzy Grouping in SSIS Fuzzy Lookup performs data standardization, correcting and providing missing values. Fuzzy Grouping performs a data cleaning task by identifying rows of data that are likely to be duplicates. ... For Fuzzy Grouping the comparison is done with input data itself.