Vertica merge question for doing insert and delete
I am reading the documentation for the merge command here
So in my case there are two conditions for "when not matched". not match can occur if the data is present in the source table and missing from the target table. in this case I do an insert.
if the data is missing in the source table but present in the target table, thn I have to do a delete.
by reading the documentatino above it seems I can do only one of them.