Merge Join

This transform assumes your data is sorted on the join keys. Use Sort Rows transforms on the incoming streams to enforce sorting if necessary.

Join options include INNER, LEFT OUTER, RIGHT OUTER, and FULL OUTER.

Options