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

Overlap Discovery Results

Overlap Discovery Results

The
Overlap Discovery
tab displays information on the participating columns and the overlapping percentage value. The overlap discovery results include Venn diagrams that represent the overlapping data in pairs of columns and the date and time when you last performed overlap discovery.
You can click a column and select
Verify
to view the results as a Venn diagram.
The following table describes the overlap discovery properties:
Property
Description
Left Column
The primary column against which the remaining columns are compared for overlap analysis.
Right Column
The column that is compared to the primary column.
% Overlap
The percentage of overlap between two columns.
Verified
Indicates that you validated the overlap results row.
Last Run Time
The date and time that the overlap discovery last ran.
Informatica Developer displays each overlapping pair two times in the overlap discovery results. Consider data sources Items and Orders. Items has columns "m" and "n." Orders has columns "p" and "q."
The following table shows the overlap discovery results for Items and Orders:
Left Column
Right Column
Items
-
m
Orders.p
m
Orders.q
n
Orders.p
n
Orders.q
Orders
-
p
Items.m
p
Items.n
q
Items.m
q
Items.m

0 COMMENTS

We’d like to hear from you!