Column Profile Results in Informatica Analyst Overview
View profile results to understand the structure of data and analyze its quality. You can view the profile results after you run a profile. You can view a summary of the columns and rules in the profile and the values, patterns, datatypes, and statistics for columns and rules.
After you run a profile, you can view the profile results in the Column Profiling, Properties, and Data Preview views. You can export value frequencies, pattern frequencies, or drilldown data to a CSV file. You can export the complete profile summary information to a Microsoft Excel file so that you can view all data in a file for further analysis.
In the Column Profiling view, you can view the summary information for columns for a profile run. You can view values, patterns, datatypes, and statistics for each column in the Values, Patterns, Datatypes, and Statistics views.
The Analyst tool displays rules as columns in profile results. The profile results for a rule appear as a profiled column. The profile results that appear depend on the profile configuration and sampling options.
The following profiling results appear in the Column Profiling view:
- •The summary information for the profile run, including the number of unique and null values, inferred datatypes with maximum conformance, and the date and time of the last profile run.
- •Values for columns and the frequency in which the value appears for the column. The frequency appears as a number, a percentage, and a chart.
- •Value patterns for the profiled columns and the frequency in which the pattern appears. The frequency appears as a number and percentage.
- •All the inferred datatypes with their statuses for each column. The frequency of inferred datatypes appears as a number and percentage.
- •Statistics about the column values, such as average, length, and top and bottom values.
Note: You can select a value or pattern and view profiled rows that match the value or pattern on the Details panel.
In the Properties view, you can view profile properties on the Properties panel. You can view properties for columns and rules on the Columns and Rules panel.
In the Data Preview view, you can preview the profile data. The Analyst tool includes all columns in the profile and displays the first 100 rows of data.