Profile Results
You can view the profile results after you run a profile. You can view a summary of values, patterns, and statistics for columns and rules in the profile. You can view properties for the columns and rules in the profile. You can preview profile data.
The following table describes the profile results for each profile type:
Profile Type | Results |
|---|
Column profile | - - Number and percentage of null, distinct, and non-distinct values in columns and the inferred data types for column values.
- - Frequency and character patterns of data values in a selected column and a statistical summary for the column.
- - Data types inferred by analyzing column data.
- - Documented data type for the data.
- - Maximum and minimum values.
- - Date and time of the profile run.
|
Primary key profile | - - Number and percentage of unique, duplicate, and null values for inferred primary key candidates.
- - Number of key violations in the inferred primary key candidates.
|
Functional dependency profile | - - Inferred functional dependencies.
- - Number of functional dependency violations.
|
Foreign key profile | - - Primary and foreign key columns that meet the primary-foreign key inference criteria you defined.
- - Number of data values that match between the primary and foreign keys, expressed as a percentage.
- - Type of relationship defined for the primary and foreign key columns before the profile run.
|
Join profile | - - Venn diagram that shows the relationships between columns.
- - Number and percentage of orphaned, null, and joined values in columns.
|
Overlap discovery | - - Percentage of ovelap between two columns.
- - Venn diagram that shows the overlap between columns.
|
Data domain discovery | - - Column name and data that match predefined data domains.
- - Data domain group that the column belongs to and its data type.
|
Enterprise discovery | - - Column profile results.
- - Data domain discovery results.
- - Primary key discovery results.
- - Foreign key profile results in both graphical and tabular views.
|
You can use third-party reporting tools to read profile results from the profiling warehouse. Informatica provides a set of profile views that you can customize for the profile statistics that you want to read. These views are based on common types of profile statistics and profile results analysis.