SSIS - Fuzzy Look up Transformation

Source:SSIS Fuzzy Look up Transformation

Fuzzy Lookups: kind same as lookup.

Table:City_ID (a) Table:City_Names (b)( LookUp Table)

CName City_ID Name City_ID

San Jose San Jose 100

SanJose

Update City_ID

Set a. City_ID=b.City_ID

where a.Name=b.Name

--Above the Look UP

But in Fuzzy Look Up For 'SanJose' also it will update to 100.( as here if it matches similarly pick up)

Settings:

Fuzzy LookUp

Advanced Tab:

Similarity threshold=0.00%

Note:When Similarity threshold=0.99% it acts like Look Up Transformation.