Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

RAND

RAND

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

Syntax

RAND( seed )
The following table describes the argument for this command:
Argument
Required/
Optional
Description
seed
Optional
Numeric. Starting value for the Integration Service to generate the random number. Value must be a constant. If you do not enter a seed, the
PowerCenter Integration Service
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, the
PowerCenter Integration Service
generates the same sequence of numbers.

Example

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