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
中文
  • Informatica Data Quality 10.0
  • 所有产品

目录

Search

  1. Data Discovery 简介
  2. 使用 Informatica Analyst 的 Data Discovery
  3. 使用 Informatica Developer 执行数据发现

Data Discovery Guide

Data Discovery Guide

上一个 下一个

Column Profile Concepts OverviewProfiles Overview

Column Profile Concepts Overview
Profiles Overview

A column profile determines the characteristics of columns in a data source, such as value frequency, percentages, and patterns.
Column profiling discovers the following facts about data:
  • The number of null, distinct, and non-distinct values in each column, expressed as a number and a percentage.
  • The patterns of data in each column and the frequencies with which these values occur.
  • Statistics about the column values, such as the maximum and minimum lengths of values and the first and last values in each column.
  • Documented data types, inferred data types, and possible conflicts between the documented and inferred data types.
  • Pattern and value frequency outliers.
You can configure the following options when you create or edit a profile:
  • Column profile options. You can select the columns on which you want to run a profile, choose a sampling option, and drill-down option.
  • Add, edit, or delete filters and rules.
In the profile results, you can add comments and tags to a profile and to the columns in a profile. You can assign business terms to columns.
The Model repository locks profiles to prevent users from overwriting work with the repository profile locks. The version control system saves multiple versions of a profile and assigns a version number to each version. You can check out a profile and then check the profile in after making changes. You can undo the action of checking out a profile before you check the profile back in.
Create scorecards to periodically review data quality. You create scorecards before and after you apply rules to profiles so that you can view a graphical representation of the valid values for columns.
Use the Scheduler Service to schedule profiles and scorecards to run at a specific time or intervals. The Scheduler Service manages schedules for profiles, scorecards, deployed mappings and deployed workflows. You can create, manage, and run schedules in Informatica Administrator.
You can configure the Data Integration Service to use operating system profiles. After you configure, the Data Integration Service runs the profiles and scorecards with the permission of the operating system user you define in the operating system profile. You can select the operating system profile in the Analyst tool and the Developer tool.