difference between the fuzzy lookup and fuzzy grouping in ssis

Dear Friends,

i think fuzzy lookup

COMPARES WHAT WE ARE MAPING THE COLUMNS WITH SPELLING (IT WILL REJECT ATLEAST 1 LETTER IS DIFFRENT IN ANY RECORD MAPPED COLUMN) EX: RAVI != REVI

what is fuzzy grouping ? please explain

regards

koti

Fuzzy grouping lets you find patterns in your data that could represent duplicated data. i.e., it could match address data like "1234 Main St." to "1234 Main Street" and push these into one record. Fuzzy lookup helps you to clean dirty data by comparing your input with an outside source.

|||

Koti,

I'm just noticing your other threads here... If you have any further questions about what a component does, you should first try to find out about it through the books on-line feature of sql. Most of these components you have asked about have rather good documentation...

Please, look for the documentation BEFORE posting questions like this...

Thanks for your time.

Eric