Data Discovery Guide > Part II: Data Discovery with Informatica Analyst > Enterprise Discovery Results in Informatica Analyst > Summary View
  

Summary View

The Summary view displays a summary of the column profile results and data domain discovery results. You can view the data domain names that have matches in columns and number of columns with data domain matches. The column statistics include the number of columns for the top 10 pattern matches, all unique values, and all null values. The column statistics also include the number of columns that have data type conflicts between inferred data types and documented data types.

Summary View Profile Results

The Summary view displays enterprise discovery results in Data Domain Discovery and Column Profiling sections.

Data Domain Discovery

The following table describes the columns in the data domain discovery results:
Column name
Description
Name
Name of the data domain.
Found in Columns
The total number of columns that have a data domain match.
Profile
Name of the profile that contains the matching column.
Column Name
Name of the matching column.
%Data Conformance Percentage
The minimum conformance percentage of rows required for a data domain match.
Connection Name
Name of the relational database connection.
Source Name
Name of the data source.
Inference Status
Data domain inference status. The statuses are Accepted, Rejected, and Inferred.
%Null
The percentage of null values for the column.
Total Rows
The total number of rows.
Conforming Rows
The minimum number of rows required for a data domain match.
Column Name Match
Indicates whether the column name matches a data domain name.
Documented Data Type
Data type declared for the column in the profile object.
Verified
Indicates the validation of the data domain match on all rows of the data source.
Last Run Time
Date and time of the last profile run.

Column Profiling

The following table describes the columns in the column profile results:
Column name
Description
Name
Name of the profile result type, such as pattern, 100% Nulls, and 100% Unique.
Found in Columns
Total number of columns that have matching profile result type.
Profile
Name of the profile that contains the matching column.
Connection
Name of the relational database connection.
Data source
Data source of the profile.
Number of columns
Number of columns in the profile that have matching profile result type.

Viewing Data Domain Discovery Results

You can click a data domain name to view its data domain discovery results. You can open specific profiles from the data domain discovery results.
    1. Run a profile to perform enterprise discovery.
    2. Verify that you are in the Summary view.
    3. Click a data domain under the Data Domain Discovery section to view its discovery results.
    A list of profiles that contain the data domain appear in the right pane.
    4. Select a row in the right pane, if required.
    The hyperlinks to the profile appear in Blue color.
    5. Click the profile name link or column name link to open the profile.
    The profile opens and displays the data domain discovery results. The Analyst tool highlights the row with the data domain in the results. If required, you can curate the profile results for further effective use, such as Discovery Search.
    6. To go back to the Summary view, click Back to Enterprise Discovery..

Viewing Column Profile Results

You can view the column profile results of enterprise discovery in the Summary view. You can open specific profiles from the data domain discovery results.
    1. Run a profile to perform enterprise discovery.
    2. Verify that you are in the Summary view.
    3. To view the details of inferred patterns, click one of the top 10 patterns under the Column Profiling section.
    A list of profiles that contain the inferred pattern results appear in the right pane.
    4. To view information such as all null values, all unique values, or data type conflicts, click 100% Nulls, 100% Unique, or Conflicting inferred vs. documented datatypes.
    The matching list of profiles appears in the right pane.
    5. Click the profile name link or column name link to open the profile.
    The profile opens and displays the column profile results.
    6. To go back to the Summary view, click Back to Enterprise Discovery..