Data Quality Analyst User Guide(3)

Chapter 5: Scorecards.......................................................... 41

Scorecards Overview..................................................... 41

Adding Columns to a Scorecard........................................... 42Running a Scorecard.................................................. 42Viewing a Scorecard................................................... 43Drilling Down on Columns............................................... 43Editing a Scorecard................................................... 43Creating a Group..................................................... 44Editing a Group...................................................... 45Deleting a Group..................................................... 45Viewing Trend Charts.................................................. 46Rules and Guidelines for Scorecards........................................... 46

Chapter 6: Reference Tables.................................................... 47

Reference Tables Overview................................................. 47

Reference Table Properties.............................................. 47Create Reference Tables................................................ 49Reference Table Management............................................ 52Audit Trail Events.................................................... 54Rules and Guidelines for Reference Tables.................................... 55

Chapter 7: Metadata Bookmarks................................................ 56

Metadata Bookmarks Overview............................................... 56

Creating a Metadata Bookmark............................................ 56Opening a Metadata Bookmark............................................ 57

Chapter 8: Exception Record Management...................................... 58

Overview............................................................. 58Database Table Structural Requirements........................................ 59Exception Management Process Flow.......................................... 59View, Filter, and Edit Records................................................ 59

Chapter 9: Exception Management Prerequisites................................ 60

Overview............................................................. 60Required Columns and Tables for Bad Record Management............................ 61

Table of Contents iii

Informatica data quality Analyst guide version 9

Required Columns for Duplicate Record Management................................ 61Reserved Column Names .................................................. 62

Chapter 10: Exception Management Tasks ...................................... 63

Overview............................................................. 63Importing a Database for Exception Management................................... 64Viewing and Editing Bad Records............................................. 64Viewing and Filtering Duplicate Record Clusters ................................... 65Editing Duplicate Record Clusters............................................. 65Consolidating Duplicate Record Clusters......................................... 65Updating the Record Status................................................. 66Viewing and Exporting the Audit Trail........................................... 66

Index.............................................................. 68

iv Table of Contents

Informatica data quality Analyst guide version 9

Preface

The Informatica Analyst User Guide is written for data quality analysts. It describes how to use InformaticaAnalyst. This guide assumes that you have an understanding of data quality concepts, flat file and relationaldatabase concepts, and the database engines in your environment.

Informatica Resources

Informatica Customer Portal

As an Informatica customer, you can access the Informatica Customer Portal site at

access to the Informatica customer support case management system (ATLAS), the Informatica How-To Library,the Informatica Knowledge Base, the Informatica Multimedia Knowledge Base, Informatica ProductDocumentation, and access to the Informatica user community.

Informatica Documentation

The Informatica Documentation team takes every effort to create accurate, usable documentation. If you havequestions, comments, or ideas about this documentation, contact the Informatica Documentation team throughknow if we can contact you regarding your comments.

The Documentation team updates documentation as needed. To get the latest documentation for your product,Informatica Web Site

about Informatica, its background, upcoming events, and sales offices. You will also find product and partnerinformation. The services area of the site includes important information about technical support, training andeducation, and implementation services.

Informatica How-To Library

The How-To Library is a collection of resources to help you learn more about Informatica products and features. Itincludes articles and interactive demonstrations that provide solutions to common problems, compare features andbehaviors, and guide you through performing specific real-world tasks.

v

Informatica data quality Analyst guide version 9

Informatica Knowledge Base

Use the Knowledge Base to search for documented solutions to known technical issues about Informatica

products. You can also find answers to frequently asked questions, technical white papers, and technical tips. Ifyou have questions, comments, or ideas about the Knowledge Base, contact the Informatica Knowledge BaseInformatica Multimedia Knowledge Base

As an Informatica customer, you can access the Informatica Multimedia Knowledge Base at

that help you learn about common conc …… 此处隐藏：6143字，全部文档内容请下载后查看。喜欢就下载吧 ……