Problem with fuzzy lookup result

• Mr.Sahand

  Old Hand

  Points: 391

  More actions

  September 15, 2014 at 9:49 am

  #397344

  Hi All,

  To make things simple lets say I have a Client table with Fields: ClientID, PCode, Region

  I have a look up Region table with Fields: ID, PostCode, Region

  The Client table has one row : 123, 3075, THOMASTOWN

  The Region has 2 rows: 1,3074,THOMASTOWN ; 2,3075,LALOR

  I am trying to cleanse some data using SSIS fuzzy lookup.

  I use the Client as source and the lookup as Reference. when the Max number of matches to output per lookup is 1 the result is 123,3075,THOMASTOWN , 1,3074,THOMASTOWN. in this case ssis prefer the value of region over the value of pcode. It works fine it the option set to 2,3 or 4.

  But when I increase this option to higher (30,100) the match record result is just 1! and the record has the smallest similarity value among all! Am I doing something wrong here?

  Thanks and sorry if the text has gone a bit messy.:-D