...
The following sample illustrates the usage:
| Code Block |
|---|
samples/transformations/Merge rows - mergs 2 streams of data and add a flag.ktr.ktr
|
This step can also be used in conjunction with the Synchronize after merge step. The flag column is then used to execute updates/inserts/deletes on a target table.
Options
Option | Description |
|---|---|
Step name | Name of the step;this name has to be unique in a single transformation. |
Reference rows origin | Specify the step origin for the reference rows <- Stream with original rows, or rows you want to compare the new rows to. |
Compare rows origin | Specify the step origin for the compare rows.<- Stream with new rows |
Flag fieldname | Specify the name of the |
flag field on the output stream. | |
Keys to match | Specify fields containing the keys on which to match;click Get key fields to insert all of the fields originating from the reference rows step |
Values to compare | Specify fields contaning the values to compare; click Get value fields to insert all of the fields from the originating value rows step. Key fields do not need to be specified here. |
Metadata Injection Support (7.x and later)
...