Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Informatica Data Quality 10.5
  • All Products

Table of Contents

Search

  1. Preface
  2. Introduction to Exception Management
  3. Exception Tasks
  4. Duplicate Record Tasks
  5. Task Management

Exception Management Guide

Exception Management Guide

Back Next

Duplicate Task Metadata

Duplicate Task Metadata

When you export data from a correct duplicates task or a review duplicates task, you export all of the task data and metadata. The export operation adds the metadata columns to the start of the delimited file. The export operation creates the same columns for a correct duplicates task and for a review duplicates task.
The following table describes the metadata columns that you export with the task data:
Column Name
Description
ROW_IDENTIFIER
The number of the record row in the database table.
SEQUENTIAL_CLUSTER_ID
An identifier value for the cluster in the database table. The workflow uses the value to sort the cluster rows in the database.
CLUSTER_ID
The value that the identifies the cluster to which the record belongs.
MATCH_SCORE
A value that indicates the degree of similarity between two records in the cluster. The score is a decimal value between 0 and 1.
IS_MASTER
A value that identifies preferred records in the table. The values are Y for preferred records and N for other records.
UPDATED_STATUS
The update status of the record in the cluster.
A record can have one of the following status values:
  • UPDATED. The user updated the record.
    Users can update the preferred record in a cluster.
  • NULL. The user did not update the record.
  • EXTRACTED. The user moved the record from the original cluster.
USER_COMMENT
The most recent note that a user added to the cluster in the Analyst tool.
REVIEW_STATUS
The current review status of the cluster.
A cluster can have one of the following review status values:
  • NULL. The user did not update the review status.
  • REVIEWED. The user reviewed the cluster that contains the record.
  • REJECTED. The user rejected the cluster that contains the record.
  • ACCEPTED. The user approved the cluster that contains the record.
WORKFLOW_ID
An identifier for the workflow that generated the task instance.
0 COMMENTS
We’d like to hear from you!