The Target_CustomerConsolidate table receives records from the Cluster Output group. The Cluster Output group returns records that might be duplicate records. The records in the Target_CustomerConsolidate table need manual review in the Analyst tool.
The following image shows some of the records and the fields in the Target_CustomerConsolidate table:
The record contains the following fields:
Row_Identifier
A number that uniquely identifies each row in the table.
Sequential Cluster ID
A sequential identifier for each cluster to review in a Human task. The Duplicate Record Exception transformation adds the sequential cluster ID to records in the Cluster Data output group.
Cluster ID
A unique identifier for a cluster. The Match transformation assigns a cluster ID to all the output records. Duplicate records and possible duplicate records share a cluster ID. A unique record receives a cluster ID, but the record does not share the ID number with any other record.
Score
Match score that indicates the degree of similarity between a record and another record in the cluster. Records that require manual review have match scores less than .95 and greater than .80.
Is Master
Indicates whether the record is the preferred record in the cluster.
WorkflowID
The WorkflowID is DummyWorkflowID because the transformation is not in a workflow.
Record Fields
The other fields in the record contain the customer source data.
ASK INFAPreview
