Overlap - RESULTS - Data - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
Release Number
July 2017
English (United States)
Last Update
Product Category
  1. On the Overlap dialog box, click on RESULTS.
  2. Click on data (note that the RESULTS tab will be grayed-out/disabled until after the analysis is completed).
    Overlap > Results > Data

    Results data, if any, is displayed in a data grid as described in RESULTS Tab.

    The following is a description of the results returned by the analysis. Note that the number of tables selected affects the structure of the table. If an output table is created, the columns in bold below comprise the Unique Primary Index (UPI) of the output table.

    Overlap Results Data
    Name Type Definition
    xidx BYTEINT Generated table identification number. Note that the values 1 and 2 are reserved for the number of records and number of unique records in the table
    xtable CHAR (8) Table that the overlap key resides in, as specified by the “table” parameter. Note that “#records” “#uniques” are included as pseudo-table names so that COL will consist of the number of records and number of unique records in the table. The length of this attribute is a minimum of 8 or a maximum of all table/table alias names.
    COL FLOAT Count of the overlapping records between each pair-wise combination of tables. There will be a COL column generated for each table defined.