Multiple choice technology

What is the measure you need to use to measure similarity between a set of values in a Fuzzy Lookup?

  1. _Similarity

  2. _Confidence

  3. Similarity

  4. FuzzyComparionFlags
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL Server Fuzzy Lookup transformations, the _Similarity column returns a score from 0 to 1 indicating how closely two field values match. This is the measure used to determine similarity between values.

AI explanation

In SQL Server Integration Services' Fuzzy Lookup transformation, the _Similarity output column reports how closely a matched value resembles the input value, and it's the metric used to judge match quality. _Confidence measures something different (how sure the algorithm is that it found the best available match, not similarity), and the other listed names aren't actual Fuzzy Lookup outputs.

Keep practicing — related questions