fuzzy lookup

Hi Friends,

Can some body briefly explain me what is the difference between fuzzy lookup and fuzzy grouping?

thanks and regards

Ruther wrote:

Hi Friends,

Can some body briefly explain me what is the difference between fuzzy lookup and fuzzy grouping?

thanks and regards

One is a lookup, the other is a group by? The fuzzy grouping is good for finding duplicates while the lookup is good for finding matches.|||

If the fuzzy lookup is analogous to the regular LOOKUP component in SSIS then Fuxxy Grouping is most analogous to the AGGREGATE component.

Under the covers the Fuzzy Grouping does the same as the Fuzzy Lookup, it then groups the data according to the looked up value (I think).

BOL will have all the answers.

-Jamie

sql