Export (0) Print
Expand All

Create Relationships

Use the Create Relationships dialog box to edit mappings between the source columns and the lookup table columns that you configured in the Fuzzy Lookup Transformation Editor, the Lookup Transformation Editor, and the Term Lookup Transformation Editor.

Note Note

The Create Relationships dialog box displays only the Input Column and Lookup Column lists when invoked from the Term Lookup Transformation Editor.

To learn more about the transformations that use the Create Relationships dialog box, see Fuzzy Lookup Transformation, Lookup Transformation, and Term Lookup Transformation.

Input Column

Select from the list of available input columns.

Lookup Column

Select from the list of available lookup columns.

Mapping Type

Select fuzzy or exact matching.

When you use fuzzy matching, rows are considered duplicates if they are sufficiently similar across all columns that have a fuzzy match type. To obtain better results from fuzzy matching, you can specify that some columns should use exact matching instead of fuzzy matching. For example, if you know that a certain column contains no errors or inconsistencies, you can specify exact matching on that column, so that only rows which contain identical values in this column are considered as possible duplicates. This increases the accuracy of fuzzy matching on other columns.

Comparison Flags

For information about the string comparison options, see Comparing String Data.

Minimum Similarity

Set the similarity threshold at the column level by using the slider. The closer the value is to 1, the more the lookup value must resemble the source value to qualify as a match. Increasing the threshold can improve the speed of matching because fewer candidate records have to be considered.

Similarity Output Alias

Specify the name for a new output column that contains the similarity scores for the selected column. If you leave this value empty, the output column is not created.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft