Data Discovery Guide > Part II: Data Discovery with Informatica Analyst > Column Profile Results in Informatica Analyst > Summary View
  

Summary View

The summary of profile results appear in a grid format in the summary view. You can use the default filters in the summary view to view specific statistics. For example, when you choose Rules, the summary view displays all the rules in the profile.
The following image shows a sample graphical view of summary view: The image shows the summary view of the profile results.
  1. 1. Default filters. You can view the profile results in the summary view based on the default filters.
  2. 2. Profile header. You can view the profile name in the header. You can use the Edit button to edit the profile, use the tag and comments icons to add or edit tags and comments, and choose the options from the Actions menu.
  3. 3. Summary view header. You can view profile-specific information in the summary view header. You can view the profile run number, total number of profile runs, number of columns and rules, and the number of rows in the profile.
  4. 4. Summary view. You can view the properties for all the columns and rules in the profile.
In the summary view, you can run or edit the profile, detect pattern or value frequency outliers, add columns to a scorecard, choose a profile run, compare two profile runs, export profile results or data domain discovery results to a Microsoft Excel spreadsheet, verify the inference results of multiple columns, add or delete comments and tags, or view profile properties.

Summary View Properties

The summary view displays the properties for all the columns and rules in a profile. The summary view includes a visual representation of the properties. You can click each summary property to sort the values of the property.
The following table describes the profile results summary properties:
Property
Description
Name
Displays the name of the column or rule in the profile.
Null Distinct Non-Distinct %
Displays the null values, distinct values, and non-distinct values in percentages for a column or rule output. You can view the values in a horizontal bar chart.
Pattern
Displays the multiple patterns in the column as horizontal bar charts. You can view the pattern characters and the number of similar patterns in a column as a percentage when you hover the mouse over the bar chart.
Value
Displays the minimum and maximum values in the column or rule output.
Length
Displays the minimum and maximum length of the values in the column or rule output.
Data Type
Displays the documented data type of the column or rule. Displays the inferred data types when you hover the mouse over the field. The Analyst tool can infer the following data types:
  • - String
  • - Varchar
  • - Decimal
  • - Integer
  • - Date
You can also view the percentage of conformance based on the inferred data types.
Note: The Analyst tool cannot derive the data type from the values of a numeric column that has a precision greater than 38. The Analyst tool cannot derive the data type from the values of a string column that has a precision greater than 255. If you have a date column on which you create a column profile with a year value earlier than 1800, the inferred data type might show up as fixed length string. Change the default value for the year-minimum parameter in the InferDateTimeConfig.xml, as required.
Data Domain
Displays the names of the data domains associated with the column along with the percentage of conformance and the number of conforming rows.
Business Term
Displays the business term assigned to the column.

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.