Function Reference > Functions > RAND
  

RAND

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

Syntax

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

Return Value

Numeric.
For the same seed, Informatica Cloud generates the same sequence of numbers.

Example

The following expression may return a value of 0.417022004702574:
RAND (1)