Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
splitcore
New Contributor II

Partial Reload and Incremental Load

Hi qliksperts!

I know you can combine a partial reload and an incremental load... But is it wort it?

Lets say you have a binary containing 5 years worth of transaction data. Each day new data becomes available so obviously one would like to include this in your data.

If you load your binary, then do a partial reload each day of an incremental load to load new data and concatenate the new data into the binary loaded table. Would that work?

1 Solution

Accepted Solutions

Re: Partial Reload and Incremental Load

Ok. it's a different point of view but I don't believe that there is an advantage against the classical and from qlik recommended way to create a data-architecture and perform incremental load approaches. I would not say that's not worked but you will create a solution which will be differ from the "standards" which mots often meant that the efforts to develop and maintain these logic will be greater - maybe you didn't work always alone and some internal or external colleagues want to support you and they will need some time more to understand when what why happens in your environment.

- Marcus

4 Replies

Re: Partial Reload and Incremental Load

splitcore
New Contributor II

Re: Partial Reload and Incremental Load

Hi Marcus.

The other question I posted works with the same data. But this is another angle on it so I did not want to combine the two questions to keep thing simpler. In this one I would like to know what happens to the data that I concatenate each day, Will it be stored in the qvw after each partial reload of the incremental load? If so it would be much faster than the standard qvd incremental load would it not?

Thanks for the replies

Re: Partial Reload and Incremental Load

Ok. it's a different point of view but I don't believe that there is an advantage against the classical and from qlik recommended way to create a data-architecture and perform incremental load approaches. I would not say that's not worked but you will create a solution which will be differ from the "standards" which mots often meant that the efforts to develop and maintain these logic will be greater - maybe you didn't work always alone and some internal or external colleagues want to support you and they will need some time more to understand when what why happens in your environment.

- Marcus

splitcore
New Contributor II

Re: Partial Reload and Incremental Load

Ah yes, from that perspective it would certainly be best to stick to the standards... I found no documentation or references to similar methods to what I described above so I was curious... I would like to run some tests with it regardless and see how it performs. But at the moment I will stick to the regular qvd incremental load. Thanks for the input I'll mark this question as answered.

Hendrik

Community Browser