A MERGE source contains multiple records that ambiguously update the same target key. What should the pipeline do?

1. Resolve source duplicates and define the intended change ordering before merging
2. Add more compute without addressing duplicates
3. Ignore the key and overwrite every target row
4. Assume source row order always determines the desired winner