I am pulling in my orders from a SQL database up to the end of 2016, then using the incremental load to pull in 2017. The problem i am having is if a order is deleted from the database in 2017, it remains in the QVD file. is it possible to remove 2017 records from the QVD file and reload fresh data.
Please give the answer of the incremental load scenario:
Yesterday we have loaded the data that contains 100 rows and today user has deleted 5 records from source database and your incremental load run so no inserted record will found because their n new record is inserted and updated but 5 record is deleted from source data. How incremental load is identify the those 5 deleted record and present in your QVD.