This process typically consists of a two types of reports. The first report is a changes only report. This report will use the initial version of the duplicate candidate report as its basis and will compare the current data against the data that was previously reported. This report should be run fairly frequently and it will report three scenarios; new duplicate candidate groupings, changes in a previously reported groupings, and groupings that have disappeared. The purpose of this report is to provide the business users knowledge about how their data is changing, and to give them small data sets to work through quickly.
The second report is the full duplicate candidate report that shows all duplicate candidates and how they are going to be resolved. This report should be run prior to each conversion cycle so the business users can have the chance to review the data and confirm how the duplicates are being identified and resolved. An important and often time not immediately obvious part about this report, is that it should also have the ability to show\hide\identify duplicate candidate groups that fit the reporting criteria as a duplicate candidate, but were previously deemed by the business that they need to be kept separate.