Introducing Radical.sh

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

IIF - Conditional Statement in Informatica

  1. Forget Code
  2. Informatica
  3. IIF - Conditional Statement
IIF is used to check given conditional statement and return true or false.

Note : The extra 'I' in the IIF clause

IIF(condition, true statement, [false statment])


When the false statement is provided, the function act as If Else condition and if the argument is omitted it acts as If condition.

Example : Provide bonus of 100USD to employee if the salary is greater than 5000 USD
IIF(Salary > 5000, 100, 0)

SalaryBonus
50000
5500100
25000