These components can work under the following three processing modes:
Inner Join
In this processing mode, only the master records in which the values of Join key fields equal to the values of their slave counterparts are processed and sent out through the output port for joined records.
For ApproximativeJoin, the name of this attribute is Matching key.
The unmatched master records can be sent out through the optional output port for master records without a slave (in ApproximativeJoin, LookupJoin or DBJoin only).
The unmatched slave records can be sent out through the optional output port for slave records without a master (in ApproximativeJoin only).
Left Outer Join
In this processing mode, only the master records in which the values of Join key fields do not equal to the values of their slave counterparts are processed and sent out through the output port for joined records.
For ApproximativeJoin, the name of this attribute is Matching key.
The unmatched slave records can be sent out through the optional output port for slave records without a master (in ApproximativeJoin only).
Full Outer Join
In this processing mode, all records, both the masters and the slaves, regardless of whether the values of Join key fields are equal to the values of their slave counterparts or not, are processed and sent out through the output port for joined records.
For ApproximativeJoin, the name of this attribute is Matching key.
Important | |
---|---|
Full outer join mode is not allowed in LookupJoin and DBJoin. |
Note | |
---|---|
Remember that Joiners parse each pair of
records (master and slave) in which the same fields of the
Join key attribute have |