| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Description
Merge rows allows you to compare two streams of rows. This is useful for comparing data from two different times. It is often used in situations where the source system of a data warehouse does not contain a date of last update.
...
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)
...