Various time ,we need to filter null values in informatica. We can remove them for further processing or other scenarios also . Check Informatica scenarios of filtering out rows with null values .
To filter our rows with null values , we can use it in Source qualifier's over ride SQL or you can use filter transformation in informatica.
Must check : Normalizer Transformation in informatica
To filter out rows containing null values or spaces, use the ISNULL and IS_SPACES functions to test the value of the port. For example, if we want to filter out rows that contain NULLs in the FIRST_NAME port, use the following condition:
IIF(ISNULL(FIRST_NAME),FALSE,TRUE)
This condition states that if the FIRST_NAME port is NULL, the return value is FALSE and the row should be discarded. Otherwise, the row passes through to the next transformation.
IIF(ISNULL(FIRST_NAME),FALSE,TRUE)
This condition states that if the FIRST_NAME port is NULL, the return value is FALSE and the row should be discarded. Otherwise, the row passes through to the next transformation.
Must check : Lookup Transformation in informatica
Searches related to how to filter null values in informatica
informatica isnull filter condition
how to handle null values in informatica
informatica filter is not null
filter null values in sql
filter null values in sql server
powershell filter null values
qlikview filter null values
isnull in informatica syntax
No comments:
Post a Comment