Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

can anyone explain the incrementalload...and where it can be used?

can anyone explain the incremental load...and where it can be used?

3 Replies
Not applicable
Author

petter
Partner - Champion III
Partner - Champion III

Incremental load is used to save time while doing a reload by not reloading all historical extracted data that you already have gathered one more time. To implement incremental load you will have to store the historical data updated with new each time you do the reload. The historical data you store in this way is much faster to merge/concatenate with the newly extracted data from your source - hence you will potentially save a lot of time by doing incremental loads.

The downside of using it is that it requires some logic implemented in a load script and you have to maintain your historical data and make sure of their integrity. Luckily there are some best practices explaining this both in general data warehousing terms but also special technical whitepapers or technical briefs from Qlik about this in a Qlik Sense / QlikView setting.

petter
Partner - Champion III
Partner - Champion III