Overlap Results - Teradata Warehouse Miner

Teradata Profiler Plug-in User Guide

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
November 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wzn1503087325188.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2304
Product Category
Software

Overlap analysis results can be viewed in a grid, as thumbnails, and in graphs.

Grid View

The Overlap view of an analysis contains the following data, depending on the options you selected.

Name Type Definition
xidx FLOAT Generated table identification number.
xdb VARCHAR (128) Database that the variable for the overlap operation resides in, as specified by the database parameter.
xtbl VARCHAR (128) Table that the variable for the overlap operation resides in, as specified by the table parameter.
xcol VARCHAR (128) Variable that the overlap operation runs against, as specified by the column parameter. This is comma-separated if you select two or more columns.
xcnt VARCHAR (50) Total number of occurrences of this variable.
xunique FLOAT Total number of rows where this variable takes a unique value.
N number of tables selected FLOAT Total number of column overlaps between crossing tables.

Graph View

The Overlap graph is a vhann chart, where the middle is where both tables overlap. It is displayed in the Graph View tab.