Wednesday, May 16, 2012 9:27 AM
What will happen in fuzzy lookup transformation., if the value(row) is not exists in reference column(table) but it exists in source table?
Ref table source table
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?
Wednesday, May 16, 2012 10:02 AM
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.
- Proposed As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Friday, May 18, 2012 6:35 AM
Wednesday, May 16, 2012 10:07 AM
Check out the article below. It may help you.