Fuzzy lookup query

Question

Hi All,

What will happen in fuzzy lookup transformation., if the value(row) is not exists in reference column(table) but it exists in source table?

Example

Ref table                             source table

RefName                             Name

Chinna                                Chin

Reddy                                 Chinn

                                          Ravi

By applying fuzzylookup on source .. chin and chinn will replace with chinna from ref table but what about ravi will it replace with reddy or will this row ignores SSIS?

Regards,

Chinna

Answer 1

it based on the similarity threshold you configured during the fuzzy lookup transformation task you set up.

you can use the conditional split to divert your lower similarity rows to another route for further analysis.

Answer 2

Hello,

Check out the article below. It may help you.

http://www.sqlteam.com/article/using-fuzzy-lookup-transformations-in-sql-server-integration-services