Output Columns - Export Matrix (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

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

If the “Create a Database Table” output option is chosen, then the following table is built by the Export Matrix analysis. Those columns in bold below comprises the Unique Primary Index (UPI).

Table built by Export Analysis
Name Type Definition
XIDX Integer Unique integer value indicating an internal “index” of the column(s) selected in Selected Tables and Columns. Used as a row identifier in order to manipulate the table with matrix algebra.
XCOL VARCHAR(30) The column names selected in Selected Tables and Columns.
<matrix_values> FLOAT A column, with the same name as that selected in Selected Tables and Columns will be generated. Data type for all is FLOAT.