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, data types, 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 drill-down data to a CSV file. You can export the 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, data types, 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 data types 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.
- •A bar chart that represents the percentage of rows with null values, unique values, and non-unique values in a column.
- • Pie charts that display the values frequencies and pattern frequencies .
Note: The Analyst tool displays a pie chart only if the total number of rows for the top 10 values on the Values tab is greater than 25% of the total number of rows in the data source.
- •All the inferred data types with their statuses for each column. The frequency of inferred data types 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.