RAND

Returns a random number between 0 and 1. This is useful for probability calculations.

RAND( seed )

Argument	Required/ Optional	Description
seed	Optional	Numeric. Starting value for Data Integration to generate the random number. Value must be a constant. If you do not enter a seed, Data Integration uses the current system time to derive the numbers of seconds since January 1, 1971. It uses this value as the seed.

Numeric.

For the same seed, Data Integration generates the same sequence of numbers.

The following expression may return a value of 0.417022004702574:

RAND (1)