Filter transformation - null conditional

How does Informatica developer handle a null returned from a condition in a filter condition? Informatica treats it as if it were a true or a false?

Example in Filter condition:

IFF(size<52, TRUE, NULL)

Hypothetical example: I have a list of clothes with a size column, I want to filter sizes greater than 52, what would happen if the size is 50?

PD: I cannot modify the condition, it is already done by someone else

1 answer

  • answered 2022-02-15 15:38 Mathias R. Jessen

    From the documentation:

    If a filter condition evaluates to NULL, the function does not select the record. If the filter condition evaluates to NULL for all records in the selected port, the aggregate function returns NULL (except COUNT, which returns 0). You can use filter conditions with aggregate functions and the CUME, MOVINGAVG, and MOVINGSUM functions.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum