Introducing Radical.sh

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

Not NULL check in Informatica

  1. Forget Code
  2. Informatica
  3. Not NULL check
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.