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 datatype conflicts between inferred datatypes and documented datatypes.

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
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
Percentage of conformance for the data domain match.
Connection Name
Name of the relational database connection.
Inference Status
Data domain inference status. The statuses are Accepted, Rejected, and Inferred.

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 in the Analyst Tool

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 the folder or project name link at the upper left corner of the Discoveries workspace.

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 datatype 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 the folder or project name link at the upper left corner of the Discoveries workspace.