The Random Number masking format generates random integers within a specified range to replace column data.
- Start Number: The lower bound of the range within which the integers should be generated.
- End Number: The upper bound of the range within which the integers should be generated.
The inputs can be any integers, including negative integers. Start Number must be less than or equal to End Number. They should be valid for the column size.
Supported Data Types
- Combinable: Yes
- Deterministic: No
- Reversible: No
- Uniqueness: Yes. The number of distinct values in the specified range must be greater than or equal to the number of values in the column.
Suppose you have an
EMPLOYEE_AGE column and you want to generate random ages from 21 through 65. You can use the Random Number masking format to generate random integers from 21 through 65, including those values.
The following table shows the original
EMPLOYEE_AGE column and the