O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Fuzzy Transformations—how SSIS understands fuzzy similarities

Suppose that input data is a csv file with department name information and there is no guarantee that the department names are spelt consistently. So you may have names such as "Management" and "Managmnt" together in the same data file. In such cases an ordinal Lookup Transform cannot detect these similarities, because Lookup checks for terms that are completely identical. This is where we need to apply some Fuzzy operations.

SSIS has two Fuzzy Transformations, which catch fuzzy similarities between terms and help us in master data management, as follows:

  • Fuzzy Grouping: This component will create groups of data rows based on their similarity threshold
  • Fuzzy Lookup: This component will ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required