Column Profile Results in Informatica Developer
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:
Profile Type | Profile Results |
|---|
Column profile | - - Percentage and count statistics for unique and null values
- - Inferred datatypes
- - The datatype 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
|