Replicating a Variable - Teradata Warehouse Miner

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

Teradata Warehouse Miner
Release Number
November 2018
English (United States)
Last Update
Product Category

It is possible to create multiple varied copies of a variable by dropping or selecting multiple columns or values onto a component of a variable that is not a folder, Text literal or Text Parameter. For the options available when dropping values onto these targets, see Applying Column Values.

The options presented to the user when multiple columns or values are dropped onto an element of a Variable are listed below.
  • Replicate Variable for each column/value
    • Precede Variable name with column/value
    • Append column/value to Variable name
    • Append counter to Variable name
  • Cancel
When preceding a variable name with a column name or value, or when appending a column name or value to a variable name, an underscore ‘_’ character is automatically added as a separator. When string values are introduced, they are trimmed of leading and trailing whitespace characters. The resulting name is then limited to the first 30 characters.
When appending a column name, value or counter, it is possible to create non-unique names, leading to an error.

Before replicating a variable, a check is made to see if the maximum number of operations that can be undone by selecting the Undo button will be exceeded. If so, a warning is given to the effect that only the last so many operations can be undone. If the replication is undone, the original variable with the last value replicated in place of the original target value remains, possibly along with some number of replicated variables.