I am pulling the data from the database and storing it as QVD file. I have used the incremental load to get only latest records.
Now i am using the QVD file which is created in the above step to load into final application. Each time i reload,i am getting all the data from QVD file. How to restrict the data load from the QVD file to load only the recently added records.
Assuming you're using QlikView, you might want to consider doing a partial reload using a QVD Load command that's based on the current contents of the table you're incrementing. This might require storing your (next) load criteria in a variable or other QVD after you perform an incremental load.
In my experience using incremental loads, the big efficiency is in the incremental querying of the database, not so much in the loading of QVDs.
I've used the incremental load to get the data from database to QVD. Now i am using QVD files to load into final QVQ application.
Whenever i load the data from the QVD file, i have to load all the data all the time. So can we load only the latest records from the QVD into the final application.
