Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

Fuzzy Lookup Transformation Editor (Advanced Tab)

Use the Advanced tab of the Fuzzy Lookup Transformation Editor dialog box to set parameters for the fuzzy lookup.

To learn more about the Fuzzy Lookup transformation, see Fuzzy Lookup Transformation.

Maximum number of matches to output per lookup

Specify the maximum number of matches the transformation can return for each input row. The default is 1.

Similarity threshold

Set the similarity threshold at the component level by using the slider. The closer the value is to 1, the closer the resemblance of the lookup value to the source value must be to qualify as a match. Increasing the threshold can improve the speed of matching since fewer candidate records need to be considered.

Token delimiters

Specify the delimiters that the transformation uses to tokenize column values.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.