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)