Multiple choice technology

What does a non-zero number return from an expression in Filter transformation represent?

  1. False

  2. True

  3. Its not valid return

  4. Filter cannot take expressions

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Informatica Filter transformation, the filter condition is evaluated for each row. A non-zero return value (including negative numbers) is treated as TRUE, allowing the row to pass through. A zero return is treated as FALSE, filtering the row out.