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

4 comments:

  1. What if I need to add 1 more condition here, say REGION='NA'

    ReplyDelete
  2. iif(isnull(ACCOUNT),false,true) and REGION='NA'

    can I write like this? If both conditions should satisfy for the records to be loaded into target

    ReplyDelete
  3. iif(isnull(ACCOUNT),iif(REGION="NA",False),true)
    u can write like this in expression, after that filter the rows which throws false.

    ReplyDelete
  4. AccountId != null AND LA_Account__c = null AND User_Unique_ID__c = null

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis