- Fuzzy match: Enable fuzzy matching based on English language pronunciation using the doublemetaphone function.
Create range join
Values in the join key columns are matched across a range of values, instead of matching single value to single value. When range joins are enabled, you can set the Condition value between the two join key columns when specifying the join keys. For more information, see Configure Range Join.
Add multiple join keys
For more complex join operations, you can add additional join keys to evaluate. Multi-key joins can be helpful for: