Joiners serve to join data from more data sources according to key values.
We can distinguish Joiners according to how they process data. Most Joiners work using key values.
Some Joiners read data from two or more input ports and join them according to the equality of key values.
joins two or more data inputs according to the equality of key values.
joins two or more sorted data inputs according to the equality of key values.
Other Joiners read data from one input port and another data source and join them according to the equality of key values.
joins one input data source and a database according to the equality of key values.
joins one input data source and a lookup table according to the equality of key values.
One Joiner joins data according to the user-defined relation of key values.
joins two or more sorted data inputs according to the user-defined relation of key values (!=, >, >=, <, <=).
joins data flows by tuples.
creates a Cartesian product of records from connected input ports.