As we can read this in manual if we have to delete some records from our qvd-file there is one way. It's load "primary key" from our table in the database and inner join it to the table.
In case to change record the WhereNotExists works perfect:
1. load new and changed records
2. concatenate qvd with wherenotexists (id)
3. save table into qvd.
This use case is same as Incremental load where you don't want the first scenario i.e. insert only.
For Updating or overwriting the records in qvd -
- use where Not Exists (primary_key) in qvd load while concatenating the source file table
For deleting the records from qvd
- Just load primary key from qvd file after loading the above tables and create the inner join with this table load.
The inner join will compare the source file with qvd and will exclude the records from resultant tables which are missing (deleted) from source file.