I have 2 QVD's, one from a Full data load QVD-FULL and the other which has been incrementally loaded QVD-INC. In theory they should be identical, but unfortunately they have different numbers of rows.
They both have a unique ID field called say ID.
What would be an approach to find out :
ID values in FULL and not in INC
ID values in INC and not in FULL
Here are a couple of small sample Inline Loads of test data. In reality the QVD's have a few millions rows, but I could easily trim them down to a few hundred thousand rows and the comparison would still be meaningful.