IIF - Conditional Statement in Informatica

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