Applying Column Values - 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

When one or more values selected from the Values display are dropped or otherwise selected on top of an existing element in the tree, then numeric, string or date literals are created as appropriate for each column value and one of the following menus are displayed. These options are provided primarily to make it easy to create lists of values in a text literal or text parameter.

  • Single value applied to a Text Literal or Text Parameter without an existing value
    • Set text equal to value
    • Replace this SQL element
  • Single value applied to a Text Literal or Text Parameter with an existing value
    • Replace text with value
    • Add value to list
    • Replace this SQL element
  • Multiple Values applied to a folder (such as under an IN/NOT IN operator)
  • Add one Literal element per value
    • Add one Literal Parameter per value
    • Add Text Literal with a list of all values
    • Add Text Parameter with a list of all values
  • Multiple values applied to a Text Literal or Text Parameter without an existing value
    • Set text equal to list of values
  • Multiple values applied to a Text Literal or Text Parameter with an existing value
    • Replace text with list of values
    • Append list of values to text
  • Multiple values applied to another element (other than Text or folder)
    • Replicate Dimension for each value

The final option for replicating dimensions has already been described above.