The Transformation underlines the ‘rules’ for manipulating data streams. Each data stream must have the same structure / layout, before they can be merged.
In this guided demonstration, you will merge datastreams based on a set of rules:
• Add constant step
The Merge row (diff) compares the values between the merging rows and sets a ‘flag’.
In this guided demonstration, you will compare incoming records with reference records and then determine whether the record is Identical or needs updating, inserting, deleting:
