Transformations

Back Next

Join type

The join type determines the result set that passes to the rest of the mapping.

You can use the following join types:

Normal Join: Includes rows with matching join conditions. Discards rows that do not match the join conditions.
Master Outer: Includes all rows from the detail pipeline and the matching rows from the master pipeline. It discards the unmatched rows from the master pipeline.
Detail Outer: Includes all rows from the master pipeline and the matching rows from the detail pipeline. It discards the unmatched rows from the detail pipeline.
Full Outer: Includes rows with matching join conditions and all incoming data from the master pipeline and detail pipeline.