Announcement: New Design for docs.informatica.com!
We have updated the look and feel of docs.informatica.com. To load the latest design, press CTRL-F5 to clear the pages you previously cached on our site, or simply restart your browser.
The expression returns NULL if one of the values in the expression is null. However, you can configure an expression to return a non-null value.
If the expression refers to a lookup port, but the source data is new, the lookup port contains a default value. The default might be NULL. You can configure an IsNull expression to check for null values.
For example, the following expression checks if lookup_column is NULL: