Divide - 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

The standard Divide (/) operator is supported, generating expression / expression. Within Teradata, these operators automatically convert numeric operands to the expected result type before they are applied. Character type data is converted to FLOAT if possible before being applied. For information on the resulting data types and other specific usage like binary arithmetic result data types, see Teradata® Database SQL Functions, Operators, Expressions, and Predicates, B035-1145. When dragging a Divide into a variable, the following tree element is created.

Variable Creation > Input > Variables: SQL Elements pane - Arithmetic > Divide

Columns and/or other expressions can be moved over the (empty) branches of the tree.

A Teradata Warehouse Miner enhancement to the divide '/' operator is offered to optionally request that divide-by-zero protection be provided. If this option is requested, a NULLIF function is added in the denominator so that the overall expression evaluates to NULL if the expression in the denominator evaluates to zero. This option is enabled through the Properties panel. Double-click on Divide, or highlight it and click Properties.

Variable Creation > Input > Variables: SQL Elements pane - Arithmetic > Divide Properties