Version

    73. Joiners

    Common Properties of Joiners

    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.

      • ExtHashJoin joins two or more data inputs according to the equality of key values.

      • ExtMergeJoin 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.

      • DBJoin joins one input data source and a database according to the equality of key values.

      • LookupJoin 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.

      • RelationalJoin joins two or more sorted data inputs according to the user-defined relation of key values (!=, >, >=, <, <=).

    • Combine joins data flows by tuples.

    • CrossJoin creates a Cartesian product of records from connected input ports.