Part II: Profiling with Informatica Analyst > Column Profile Results in Informatica Analyst > Column Values
  

Column Values

The column values include values for columns and the frequency in which the value appears for the column.
The following table describes the properties for the column values:
Property
Description
Value
List of all values for the column in the profile.
Note: The Analyst tool excludes the CLOB, BLOB, Raw, and Binary datatypes in column values in a profile.
Frequency
Number of times a value appears for a column, expressed as a number, a percentage, and a chart.
Percent
Percentage that a value appears for a column.
Chart
Chart for the percentage.
Drill down
Drills down to specific source rows based on a column value.
Note: To sort the Value and Frequency columns, select the columns. When you sort the results of the Frequency column, the Analyst tool sorts the results based on the datatype of the column.