I am not sure about the way I am using QVD file for incremental load , so any suggestions are welcome.
Scenario:
I have 20 different databases with same table names and table structures,so I am loading the data in 1 table in QlikView with additional field for database name. (Where clause contains the CreationTime > LastReloadTime).
After this script executes I am concatenating the table from QVD file and storing the qvd file with STORE statement.
Qlikview file size remains 24MB in both the cases with or without incremental load.
My question is , Is it the right way to use incremental load ?
Comparing the qvw sizes with or without incremental load is not precise enough to check. A better check would be to compare the number of records. Ideally it would be good if you can get a count of the number of records in your source meeting the criterion CreationTime > LastReloadTime and then seeing if that number plus the number of records in your qvd equals the number of records you end up with in your qvw.
