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)

© Copyright Informatica LLC 2007, 2021