The type of join operation used to join the data. The four join types available in the product correspond to the standard join types defined in SQL92.
|
Value |
Description |
|---|---|
|
INNER |
Only data which has a key that was found in both input flows are sent to output. |
|
LEFT |
All records from the left (first) input flow are sent to output (even those with a key that was not found in the right flow). |
|
RIGHT |
All records from the right (second) input flow are sent to output (even those with a key that was not found in the left flow). |
|
OUTER |
All records from both input flows are sent to output (even those with a key that was not found in both flows). |
| iWay Software |