Join - INPUT - Expert Options - 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 Join dialog box, click on INPUT .
  2. Click on expert options.
    Join > Input > Expert Options

    This screen provides the option to generate a SQL WHERE clause(s) to restrict rows selected for analysis (for example, cust_id > 0).

    It may be useful to note that if a WHERE clause condition is specified on the “inner” table of a join (i.e., a table that contributes only matched rows to the results), the join is logically equivalent to an Inner Join, regardless of whether an Outer type is specified. In a Left Outer Join, the left table is the “outer” table and the right table is the “inner” table.