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 detail 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 master pipeline.
- Full Outer
- Includes rows with matching join conditions and all incoming data from the master pipeline and detail pipeline.