The Fuzzy lookup transformation is used to perform data cleansing such as standardizing data, correcting data or finding missing values. The Fuzzy grouping transformation is used to find duplicate records. In the first exercise, we’ll use Fuzzy lookup transformation to clean incorrect customer records and in the second exercise we’ll use the Fuzzy grouping transformation to find the duplicate customer records.
Exercise 1: Data cleansing using Fuzzy Lookup transformation
Exercise 2: Removing duplicates using Fuzzy grouping