Merge - INPUT - Expert Options - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
gxn1538171534877.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software
  1. On the Merge dialog box, click on INPUT.
  2. Click on expert options.
    Merge > Input > Expert Options

    One or more optional Where Clauses may be entered on this screen. Each Where Clause entered is applied only to the table currently selected on the screen.

  3. On this screen, select:
    • Select table to associate WHERE clause with — Select the table to associate an optional SQL Where Clause with.
    • Optional WHERE clause text — Enter the optional SQL Where Clause text to be associated with the selected table, restricting the selected rows. Do not include the word “WHERE” at the beginning of the text. It will be added automatically.