In Incremental Load I understood how insert, update works but couldn't understand how delete work's. If anyone could briefly tell me that. Thanks in advance.
If I understand you correctly, you are doing an incremental load of some data, updating values where appropriate but otherwise keeping old values, and now you want to delete some of the old values? You can just do that with a WHERE after either the main (old) data load or from a Resident load once all the data has been fully loaded. The WHERE clause would contain your deletion conditions.
