What is use of multi way merge?

Multiway Merge Join is a step available in the Joins Plugin for Process Studio workflows. It is used to join multiple data streams in a single step.

This step supports INNER JOIN and FULL OUTER JOIN operations while merging the input streams based on common keys.

The key difference compared to Merge Join is:

  • Merge Join → Can join only two streams at a time.

  • Multiway Merge Join → Can join multiple streams in one step.

This makes Multiway Merge Join more efficient when working with multiple datasets, as it avoids the need to perform several sequential joins.