Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

Get N digit random number in Informatica

By default RAND() function generates a value between 0 and 1. In case if you need the value to be a 5 digit random number or 4 digit random number you can use the following trick

FLOOR(RAND(1)*10000)

The above code may return some thing like 2342 or 8945 (values may change)

Tags for Get N digit random number in Informatica

Contribute to Forget Code, help others. Add snippet