Merge Rows (diff)
Compare merging records ..
Workshop - Merge Rows (diff)
The Merge row (diff) compares the values between the merging rows and sets a ‘flag’.
In this workshop, you compare incoming records with reference 'golden' records to determine whether the record is Identical requires updating, inserting, or deleting:
Merge rows (diff) stream
Merge rows (diff) database
The following content has been automatically generated by an AI system and should be used for informational purposes only. We cannot guarantee the accuracy, completeness, or timeliness of the information provided.
Any actions taken based on this content are at your own risk. We recommend seeking qualified expertise or conducting further research to validate and supplement the information provided.
Create a new Transformation
Any one of these actions opens a new Transformation tab for you to begin designing your transformation.
By clicking File > New > Transformation
By using the CTRL-N hot key
Merge Rows (diff)
Let's say we're doing a delta load of new data at specific times ..
Based on keys for comparison, we can use this step to merge reference rows (previous data) with compare rows (new data) to create merged output rows.
A flag in the row indicates how the values were compared and merged. Flag values include:
identical
The key was found in both rows, and the compared values are identical.
changed
The key was found in both rows, but one or more compared values are different.
new
The key was not found in the reference rows.
deleted
The key was not found in the compare rows.
If the rows are flagged as deleted, the merged output rows are created based upon the original reference rows stream.
For identical, new, or changed rows, the merged output rows are created based upon the original compare rows stream.
Last updated