Saturday, 15 September 2012

Filtering Null Values using Filter Transformation-Informatica

To filter Null values in Informatica you can use the ISNULL function. ISNULL Function will test the value for port and check if the value is null or not.
For example:
IIF(ISNULL(ACCOUNT_NAME),FALSE,TRUE)
Here the filter transformation will check if the input value for the port ACCOUNT_NAME is null or not. If its null value filter will discard the row and if its not null will pass the row to next transformation

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis