Table of Contents

Search

  1. Introduction to Data Discovery
  2. Data Discovery with Informatica Analyst
  3. Data Discovery with Informatica Developer
  4. Function Support Based on Profiling Warehouse Connection

Data Discovery Guide

Data Discovery Guide

Data Domain Discovery Results in Informatica Developer

Data Domain Discovery Results in Informatica Developer

Data domain discovery results display statistics about columns that match data domains, including conformance criteria for data domain match, and whether column names match data domains.
You can drill down the results further for analysis. You can also verify the results on all the rows of the data source and add the results to a data model from the editor in the Developer tool. You can sort the results based on data domains, data domain groups, and columns. You can export data domain discovery results to a Microsoft Excel file.
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
Data Domain
,
Data Domain Group
, or
Columns
view.
Connection
Name of the connection.
Status
The inference status of the column.
% Data Conformance
The minimum conformance percentage of rows required for a data domain match.
Conforming row count
The minimum number of rows required for a data domain match.
% Null
The percentage of null values for the column.
Total Rows
The total number of rows.
Column Name Match
Indicates whether the column name matches a data domain name.
Data Domain Groups
The data domain group that the data domain belongs to.
Documented Data type
Data type declared for the column in the profile object.
Drilldown
If selected, drills down on rows.
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.

0 COMMENTS

We’d like to hear from you!