Join Rows
DescriptionThe Join Rows (cartesian product) transform allows you to combine/join multiple input streams (Cartesian product) without joining on keys. It works best with one row from each stream. You can add a condition to only join when a condition is met. |
Supported Engines
|
Options
| Option | Description |
|---|---|
Transform name |
Name of the transform this name has to be unique in a single pipeline. |
Temp directory |
Specify the name of the directory where the system stores temporary files in case you want to combine more then the cached number of rows. |
TMP-file prefix |
This is the prefix of the temporary files that will be generated. |
Max. cache size |
The number of rows to cache before the system reads data from temporary files; required when you want to combine large row sets that do not fit into memory. |
Main transform to read from |
Specifies the transform from which to read most of the data; while the data from other transforms are cached or spooled to disk, the data from this transform is not. |
The Condition(s) |
You can enter a complex condition to limit the number of output row. |