Post reply

Why a Fuzzy Lookup returns Null set of values from the reference table

  • May 6, 2011 at 8:04 am

    #239765

    Hi,

    I am newly learning SSIS for my new task. I have taken a source table (fname, lname, addr1, addr2, addr3) then trying to transfer the data to customer name and address tables. When I was trying to fuzzy match on first name with similarity threshold 0.29, it is showing all Null values for the reference table fields (customer name) which doesn't match (ex: source fn: Tom, ref fn: Tomas) and threshold value as 0. Exactly match once are fine with threshold value 1 and exact reference column values. Please let me know what I am missing here.

    Thanks in advance.

  • May 6, 2011 at 9:27 am

    #1321102

    I found that if I take any other exact match column with the existing one then it is showing the reference values as well as the threshold values. I don't know the reason but, it is kind of solution to my issue. Thank you.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply