In a Joiner transformation, the join can originate from different types of sources.
The Joiner transformation supports the following types of join:
Normal
Master outer
Detail outer
Full outer
A normal or master outer join performs faster than a full outer or detail outer join.
If a result set includes fields that do not contain data in either of the sources, the Joiner transformation populates the empty fields with null values. If you know that a field returns NULL and you do not want to insert NULLs in the target, you can set a default value for the corresponding port.