Profile Guide

Back Next

Column Profile Results in Informatica DeveloperColumn Profile Results

Column profile analysis provides information about data quality by highlighting value frequencies, patterns, and statistics of data.

The following table describes the profile results for each type of analysis:

Column profiling analysis generates the following profile results:

Profile Type	Profile Results
Column profile	Percentage and count statistics for unique and null values Inferred data types The data type that the data source declares for the data The maximum and minimum values The date and time of the most recent profile run Percentage and count statistics for each unique data element in a column Percentage and count statistics for each unique character pattern in a column
Primary key profile	Inferred primary keys Key violations
Functional dependency profile	Inferred functional dependencies Functional dependency violations

Percentage and count statistics for unique and null values

Inferred data types

The data type that the data source declares for the data

The maximum and minimum values

The date and time of the most recent profile run

Percentage and count statistics for each unique data element in a column

Percentage and count statistics for each unique character pattern in a column

The following image shows the column profile results: