Table of Contents

Search

  1. Preface
  2. Part 1: Introduction to Profiles
  3. Part 2: Profiling with Informatica Analyst
  4. Part 3: Profiling with Informatica Developer

Profile Guide

Profile Guide

Default Filters in Summary View

Default Filters in Summary View

You can view the profile results in summary view based on the default filters.
The summary view displays the profile results for all source columns, virtual columns, and rule columns by default. The Filter By pane displays the number of columns on which you can apply the default filters.
In the summary view, you can view the profile results by using the following default filter options:
Default Filter Option
Description
Columns and rules
Displays the profile results for the source columns, and rule columns. You can expand and collapse the source columns and rule columns to view the results.
Columns
Displays the profile results for the source columns.
Rules
Displays the profile results for the rule columns.
100% null
Displays the profile results for the columns that have 100% null values.
100% distinct
Displays the profile results for the columns that have 100% distinct values.
100% constant
Displays the profile results for the column that have the same value for all records. For example, 100% constant filter includes the profile results of a Country column if it contains only a "USA" value.
Conflicting data types
Displays the profile results for columns where the documented data type and inferred data type do not match. For example, the filter displays the column CustomerTier because the documented data type for the column is Integer (2) and the inferred data type is string.
Inferred data domains
Displays the profile results for the columns where the inferred data domain is the same as the configured data domain.
Pattern outlier
Displays the profile results for the columns that have pattern outliers.
Value frequency outlier
Displays the profile results for the columns that have value or frequency outliers.

0 COMMENTS

We’d like to hear from you!