Home > Software > QlikView
Interview Questions   Tutorials   Discussions   Programs   Videos   

QlikView - What is Incremental Load in qlikview?

asked SRVMTrainings February 23, 2015 10:12 PM  

What is Incremental Load in qlikview?


1 Answers

answered By   0  

Incremental load is a very common task in relation to data bases. It is defined as loading nothing but new or changed records from the database. All other data should already be available, in one way or another. With QVD Files it is possible to perform incremental load in most cases. The basic process is described below:

  1. Load the new data from Database table (a slow process, but loading a limited number of records).
  2. Load the old data from QVD file (loading many records, but a much faster process).
  3. Create a new QVD file.
  4. Repeat the procedure for every table loaded.

The following basic cases can be identified:

1) Case 1: Append Only (typically log files)

2) Case 2: Insert Only (No Update or Delete)

3) Case 3: Insert and Update (No Delete)

4) Case 4: Insert, Update and Delete

   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!