-werners-
Esteemed Contributor III

I do not use DLT, but it seems that what you want to achieve is not actually a direct merge on a target table
I think you want to combine the new incoming data only and append/merge that to the target table, correct?
If so, I would treat it like that: a join on the new data which is overwritten completely at each run, and this is appended to the target table.
Take