Hi Masthan

In theory you should be able to delete the records. That is what the Inner Join in Step 5 in my original post is for.

For example, say we have the following table in the QVD:

And then the source changes to the following:

When we go through the steps, then the new row loaded will be:

When you concatenate the QVD it will become:

When you Inner Join the IDs in the source file again, then ID 4 will be removed (since it is no longer in the source table's IDs) leaving you with:

This is then stored into the QVD again.

Hope this makes sense.

Regards,

Mauritz