Here is an example pattern of update, insert or delete records.

 

 

 

In that example destination table aligned with source table.

 

The flow is:

 

 

 

1.) The source and destination tables should be ordered by the corresponding queries in the Source components: 

 

 

In the Advanced editor --> Input and Output Properties set: IsSorted=true 

 

 

Besides SortKeyPosition should be defined for key: 

 

 

 

 

2.) Merge Join - type: Full outer join. 

 

 

 

 

3.) Conditional Split rules (according flow table):

 

 

 

4.) Perform the appropriate actions on the destination table via Destination components. Note that in the Delete destination (if we need it) you should use destination keys (because the source keys are null in that case).