Variable Transformation - INPUT - Primary Key - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. On the Variable Transformation dialog, click on INPUT.
  2. Click on primary key.
    Variable Transformation > Input > Primary Key

    The purpose of this window is to specify the columns that comprise the primary key of the input table or view being transformed. This is required only when null value replacement is requested in one of the requested transformations.

    If input comes from a table the primary index, columns of the table will be selected by default. To change these columns, or to enter them initially if input is from a view, use the selectors as described below.

    • Available Tables — Pull-down with the name of the input table or view.
    • Available Columns — All columns within the table or view selected in Available Tables. Highlight those columns which comprise the primary key of the table or view and either drag and drop them to Selected Primary Key Columns, or use the right arrow button > to move them over.
    • Selected Primary Key Columns — All columns within the table or view that constitute the primary key (that is, that uniquely identify each row). If undesired columns were moved into this area, highlight those columns and either drag and drop them back to Available Columns, or use the left arrow button < to move them back.