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.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

Exception Task Metadata

Exception Task Metadata

When you export data from a correct exceptions task or a review exceptions 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 exceptions task and for a review exceptions 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.
REVIEW_STATUS
The current review status of the record.
A record can have one of the following review status values:
  • NULL. The user did not update the review status.
  • REVIEWED. The user reviewed the record.
  • REJECTED. The user rejected the record.
  • ACCEPTED. The user approved the record.
WORKFLOW_ID
An identifier for the workflow that generated the task instance.
USER_COMMENT
The most recent note that a user added to the record in the Analyst tool.
UPDATED_STATUS
The current status of the record data.
A record can have one of the following status values:
  • UPDATED. The user updated the record.
  • ACCEPTED. The user accepted the record as valid.
  • REJECTED. The user rejected the record as not valid.
  • REPROCESS. The user indicated that the record needs additional analysis by another user or by another data process.
  • NULL. The user did not update the record status.
RECORD_STATUS
The record status that the workflow sets. The workflow sets the status value when it writes the record to an exception data table. The default status is INVALID.
0 COMMENTS
We’d like to hear from you!