You are not logged in.
You would have to group the data using components such as the tMatchGroup. But this kind of components is available in our subscription version of Data Quality, TDQ.
I have done the fuzy match with two databases
Source having nearly 15,00,000 records and lookup datbase having 1500 records. Final output should be the lookup database in which some columns like unique Id,address ,contact phone are updated. results coming fine but problem with performance its taking nearly 1hr time for completing the process. only 280 rows are fetching at a time . I need to complete entire process in less than 5 min.
will it possible? if possible how can do that?
I was used metaphone algorithm for fuzzy match.