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:
In this recipe, we take a look at two Fuzzy Transformations and how they can help us in real-world scenarios.