Icon

04_​Joiner_​Labs

Joiner (Labs) Demo

Demonstrates the split output feature of the joiner, the merge join columns feature, and improved performance when disabling sorted outputs.

The "merge join columns" optioncan be used to eliminate columnsthat contain the same value as perjoin condition. The "output unmatched rows toseparate ports" option can beused to output and inspectmatches and unmatched rowsseparately. The "arbitrary output order" option in the Performance settings speeds up joins asthe results do not have to be sorted. However, the joiner may produce a differentoutput order every time, depending on how much main memory is availableduring execution. DepartmentsManagers2000 rows with 500 join partners each MatchesUnmatched DepartmentsUnmatched ManagersJoins are faster when selectingunsorted output order in the performance tab.Full outer join withoutmerge join columns (4 columns)Full outer join withmerge join columns (3 columns)Output unmatched rowsto separate ports Table Creator Table Creator Data Generator Table View Table View Table View Joiner (Labs) Joiner (Labs) Joiner (Labs) Joiner (Labs) The "merge join columns" optioncan be used to eliminate columnsthat contain the same value as perjoin condition. The "output unmatched rows toseparate ports" option can beused to output and inspectmatches and unmatched rowsseparately. The "arbitrary output order" option in the Performance settings speeds up joins asthe results do not have to be sorted. However, the joiner may produce a differentoutput order every time, depending on how much main memory is availableduring execution. DepartmentsManagers2000 rows with 500 join partners each MatchesUnmatched DepartmentsUnmatched ManagersJoins are faster when selectingunsorted output order in the performance tab.Full outer join withoutmerge join columns (4 columns)Full outer join withmerge join columns (3 columns)Output unmatched rowsto separate ports Table Creator Table Creator Data Generator Table View Table View Table View Joiner (Labs) Joiner (Labs) Joiner (Labs) Joiner (Labs)

Nodes

Extensions

Links