...
- "identical" - The key was found in both streams and the values to compare are identical;
- "changed" - The key was found in both streams but one or more values is different;
- "new" - The key was not found in the reference stream;
- "deleted" - The key was not found in the compare stream.
The row coming from the compare stream is passed on to the next steps, except when it is "deleted" or "identical"When the rows are flagged as "identical" or "deleted", the output row will be created based upon the "Reference rows origin" stream. For "new" or "changed" rows, the output row will be created based upon the "Compare rows origin" stream. Subsequent steps can be used, such as the Synchronize after merge or Switch-Case step, to handle the various flagfield values.
Important: Both streams must be sorted on the specified key(s). When using the Sort step, this works fine. When you sorted If the data is sorted outside of PDI (e.g. in a SQL query), you may run into issues with the internal case sensitive/insensitive flag or other collations. Further information can be found on PDI-11440 (illustrating an issue with the Merge join step, but the issue is valid for this step as well).
...