Introducing Radical.sh

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

Floor - Integer less than or equal to current number in Informatica

  1. Forget Code
  2. Informatica
  3. Floor - Integer less than or equal to current number
Syntax 
FLOOR(numeric_value)

Example : Truncate decimal value is price 
FLOOR(price)

PRICEOUTPUT
3.43
3.993
NULLNULL
-3.14-4
-3.99-4

Note : This function will not produce the desired output when the value of precision is greater than 28 i.e there are more than 28 digits after decimal point.