Part II: Data Discovery with Informatica Analyst > Column Profile Results in Informatica Analyst > Column Statistics
  

Column Statistics

The column statistics include statistics about the column values, such as average, length, and top and bottom values. The statistics that appear depend on the column type.
The following table describes the types of column statistics for each column type:
Statistic
Column Type
Description
Average
Integer
Average of the values for the column.
Standard Deviation
Integer
The standard deviation or variability between column values for all values of the column.
Maximum Length
Integer, String
Length of the longest value for the column.
Minimum Length
Integer, String
Length of the shortest value for the column.
Sum
Numeric datatypes, such as Integer, Decimal, and Double.
Sum of all the values in the column.
Bottom
Integer, String
Lowest values for the column.
Top
Integer, String
Highest values for the column.