DSXchange

We have a job which uses Reference Match. The job receives good input data, reference data, data frequency and reference data frequency. All metadata is mapped to all output channels. It does perform correctly for the output channels Match, Clerical, Data Duplicate, Reference Duplicate and Data Residual. Though the Reference Residuals are always faulty. The correct number of rows are delivered to the output file (or database), though the file only contain the QualityStage metadata elements “qsMatchRefID” and “qsMatchType”. None of the elements from the reference data file is delivered, even though they have been mapped to the Reference Residual output. We were hoping to receive similar data as the Data Residual-output delivers in order to enable usage of the non-matching results. Do any of you know how to achieve this?

On the Outputs tab of the Match stage, drop down the list of link names, select your reference residuals link, and verify that the Mapping tab contains a complete set of column mappings.

ray.wurlod wrote:On the Outputs tab of the Match stage, drop down the list of link names, select your reference residuals link, and verify that the Mapping tab contains a complete set of column mappings.

Thank you for fast reply!

All the columns from the reference input are linked to the output. E.g. the inputs include “Title” which is mapped to all output channels. However, it is only the “qsMatchRefID” and “qsMatchType” elements which are actually included in the output results from “Reference Residual” when the job is executed! Since the metadata specifies a range of other metadata, we always receive an error message when trying to view the result as a file: “Input dataset does not have field: “Title””. Viewing the data from a database reviled that the “qsMatchRefID” and “qsMatchType” were outputted along with the right number of rows.