Part II: Data Discovery with Informatica Analyst > Data Domain Discovery in Informatica Analyst > Data Domain Discovery Results in Informatica Analyst
  

Data Domain Discovery Results in Informatica Analyst

Data domain discovery results display statistics about columns that match data domains, including the percentage of matching column data and whether each column name matches a data domain. You can drill down the results further for analysis and verify the results on all the rows of the data source.
You can sort the results based on data domains, data domain groups, and columns.
The following table describes the data domain discovery results:
Column name
Description
Name
Name of the data domain, data domain group, or column based on whether you select the View by Data Domains, View by Data Domain Group, or View by Columns view.
Note: The default view lists all data domains.
% Data conformance
Percentage of column data that matches a data domain.
Conforming row count
Total number of rows that matches a data domain.
% Null
Percentage of null values for the column.
Total rows
Total number of rows in the data source.
Column Name Match
Determines whether a column name matches a data domain name.
Data domain group
The data domain group that the data domain belongs to.
Documented datatype
Datatype declared for the column in the profile object.
Status
The inference status of the data domain. The statuses are Inferred, Approved, and Rejected.
  • - Inferred. Indicates the inferred data domain for the column.
  • - Approved. Indicates an approved data domain for the column. When you approve a data domain, you commit the data domain to the Model repository.
  • - Rejected. Indicates a rejected data domain for the column.
Drilldown
If selected, drills down on column data.
Verified
Determines whether validation of the data domain match on all rows of the data source is complete.
Time of last profile run
Date and time of the last profile run.

Viewing by Data Domain Groups in Informatica Analyst

You can view data domain results sorted by data domain groups.
    1. Run the profile to view its results.
    2. Click Domain Discovery if the tab is not selected by default.
    3. From the list above the Name field, select View by Data Domain Group.
    You can view the column results for each data domain group.

Viewing by Columns in Informatica Analyst

You can view data domain results sorted by columns in the data source.
    1. Run the profile to view its results.
    2. Click Domain Discovery if the tab is not selected by default.
    3. From the list above the Name field, select View by Columns.
    You can view results for each column, further sorted by data domain groups associated with the column.

Approving Data Domains

You can approve multiple data domains in the Analyst tool.
    1. In the Navigator, select the project or folder that contains the profile.
    2. Click the profile to open it.
    The profile opens in a tab.
    3. In the Data Domain Discovery view, select a row.
    4. Click Actions > Approve.
    The status of the column or data domain changes to Approved.
    5. To restore the inferred status of the column or data domain, select the row and click Actions > Reset.

Rejecting Data Domains

When you open the profile results, the Analyst tool displays approved data domains by default. You can show or hide the rejected data domains.
    1. In the Navigator, select the project or folder that contains the profile.
    2. Click the profile to open it.
    The profile opens in a tab.
    3. In the Data Domain Discovery view, select a row.
    4. To reject inferred data domains, click Actions > Reject.
    The Analyst tool removes the rejected data domain from the data domain discovery results.
    5. To view the rejected data domains, click Actions > Show Rejected.
    6. To hide the rejected data domains, click Actions > Hide Rejected.