topic incremental load from qvd in QlikView

incremental load from qvd

Tue, 22 Apr 2014 09:54:09 GMT

Hello

I have a question Again about increment load.

Lets say i have an intial load into a QVD.

So my first QVD contains data from 1st Marts to YesterDay.

Then increment from yesterday to today and concatenate this with my initial load (Then i have QVD with all data)

But then i always have to full load this QVD file into a QVW file.

How can i keep my initial load in the QVW, and only load the incremental load into qlikview (but still have all the data for all periods?)

Should i then save the incremental load in different QVDs and load these or what?

Re: incremental load from qvd

Gysbert_Wassenaar — Tue, 22 Apr 2014 09:59:09 GMT

You can try using Partial Load to do this. But you should really test if simply loading all the data from the qvds isn't just as fast. An optimised load from a qvd is very fast. See this discussion: partial reload

Re: incremental load from qvd

Roop — Tue, 22 Apr 2014 10:19:35 GMT

I would collate your QVDs according to need. It may be that you keep a monthly set of QVDs or a totally different set. Generally I would tend to have a set of parallel processes that generate your QVDs according to best fit.

Re: incremental load from qvd

Tue, 22 Apr 2014 10:52:39 GMT

Thomas,

You will also get the first Qvd data for that you have to make separate QVD here by I attached the rar file that showing the Example of Incremental Load.