Match outputs for the Two-source Match stage
The Two-source Match stage takes up to seven outputs. You use this stage to send records from each of the following categories to different outputs.
- Match. The matched records for both inputs.
- Clerical. The clerical review records for both inputs.
- Data Duplicate. The duplicates in the data source.
- Reference Duplicate. The duplicates in the reference source.
- Data Nonmatched. The nonmatched records from the data input.
- Reference Nonmatched. The nonmatched records from the reference input.
- Match Statistics. Summary statistics about the matching results and statistics about the matching process for each match pass.
Use the Link ordering section of the Output tab to associate the output options with specific output links. Check the Link ordering section to ensure that the records for each output option that you select are output to the intended link.
If you want, you can add other stages, such as the Funnel stage, to group some or all the output into a single file or table.
The columns that are available for output consist of all the input columns, plus more columns that are created by the match process. If you select the Match Statistics output option, ensure that you use the default names for the output columns.