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

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