Not NULL check in Informatica

Not Null check can be implemented using ISNULL function

Approach 1 : Using NOT Operator
IIF(NOT ISNULL(value), ' Input is not null',' No it is null')


Approach 2 : Checking with return value
IIF(ISNULL(value)=0, ' Input is not null',' No it is null')


Note : Approach 1 is always better and makes the code readable. Do not use Approach2.