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.