Friday 28 December 2018

Difference between Fuzzy Lookup and Fuzzy Grouping

Below are the difference between Fuzzy Lookup and Fuzzy Grouping.

Fuzzy lookup
Fuzzy Grouping
Fuzzy Lookup performs data standardization, correcting and providing missing values.
 Fuzzy Grouping performs a data cleaning task by identifying rows of data that are likely to be duplicated.
Fuzzy Lookup enables you to match input records with clean, standardized records in a reference table.
Fuzzy Grouping enables you to identify groups of records in a table where each record in the group potentially corresponds to the same real-world entity.
Fuzzy Lookup returns the closest match in order to perform the fuzzy join.
Fuzzy Grouping is useful for grouping together in order to perform two join options; Fuzzy and Exact.
For Fuzzy Lookup, the comparison is made with a reference table.
For Fuzzy Grouping, the comparison is done with input data itself.
This is blocking transformation.
This is blocking transformation.
Only input columns with the DT_WSTR and DT_STR data types can be used in fuzzy matching
Exact matching can be applied to columns of all data types except DT_TEXT, DT_NTEXT, and DT_IMAGE. The method for approximate matching of data is based on a user-specified similarity score. It provides fuzzy matching to columns DT_WSTR and DT_STR data types.

No comments:

Post a Comment

If you have any doubt, please let me know.

Popular Posts