Multiple choice technology

Joiner transformation matches null values

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Joiner transformation in Informatica does NOT match null values during join operations. Null values are treated as unequal to all other values, including other nulls. This behavior differs from SQL's ANSI standard where null comparisons return unknown (not true or false). If you need to match rows with null keys, you must handle them explicitly through expressions or filter conditions before the join.

Keep practicing — related questions