Random (Teradata Database) - 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

This function is only available when connected to a Teradata database.

The random function is a non-standard Teradata SQL feature, generating RANDOM (x, y) and returning a pseudo-random integer between x and y. When dragging a Random into a variable, the following tree element is created.

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

The integers x (Lower Bound) and y (Upper Bound) are set through the Properties panel. Double-click on Random, or highlight it and click Properties.

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