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
What if I need to add 1 more condition here, say REGION='NA'
ReplyDeleteiif(isnull(ACCOUNT),false,true) and REGION='NA'
ReplyDeletecan I write like this? If both conditions should satisfy for the records to be loaded into target
iif(isnull(ACCOUNT),iif(REGION="NA",False),true)
ReplyDeleteu can write like this in expression, after that filter the rows which throws false.
AccountId != null AND LA_Account__c = null AND User_Unique_ID__c = null
ReplyDelete