topic Re: Incremental load using QVD files in QlikView

Incremental load using QVD files

vireshkolagimat — Wed, 14 Feb 2018 16:21:35 GMT

Hi All,

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.

Thanks for the suggestion.

Regards,

Viresh

Re: Incremental load using QVD files

YoussefBelloum — Wed, 14 Feb 2018 16:47:43 GMT

Hi,

It depends on what you need.

you can use your QVD name (if there is date indication on it)

you can use dates fields to retrieve Date informations to use with a where condition.

you can create Flags before storing the QVD.

can you add more informations about what you want to do ?

Re: Incremental load using QVD files

stascher — Wed, 14 Feb 2018 16:58:02 GMT

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.

Re: Incremental load using QVD files

vireshkolagimat — Thu, 15 Feb 2018 04:32:18 GMT

Hi,

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.

Regards,

Viresh