...
In the next step, you specify the type of join and one or more join keys.
| D caption |
|---|
Specify join type and join keys. |
...
| Option | Description | ||
|---|---|---|---|
| fuzzy match | Use a fuzzy matching algorithm for key value matching.
Fuzzy matching uses the doublemetaphone algorithm for matching strings (keys). Both primary encodings of each key value must match. See DOUBLEMETAPHONEEQUALS Function. | ||
| Ignore case | Ignore case differences between the join key values for matching purposes. | ||
| Ignore special characters | Ignore all characters that are not alphanumeric, accented Latin characters, or whitespace, prior to testing for a match. | ||
| Ignore whitespace | Ignore all whitespace characters, including spaces, tabs, carriage returns, and newlines. |
Join Key Summary:
You can use these metrics to identify the likelihood of accurate matching between the join keys and the row count generated in the output.
...
