How to Check for Not NULL in Informatica

Not Null check can be done by using ISNULL function with NOT Operator

IIF(NOT ISNULL(value), ' Input is not null',' No it is null')

or

 NOT isnull(columnPort)

No comments:

Post a Comment

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...