Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental Load - QVD Generation

Hi All,

  I am a beginner in Qlik Sense. I have to modify a full load into incremental load in an application. The data is from 3 different databases. There are 3 different connections to the database (3 set of tables). In each connection there are 4 SQL Statements. How many QVD files should I create?

I am going to follow insert and update method of the incremental load process. I am not clear with the number of QVD files generation.

3 connections:

LIB Connect to xxxxxx;

LIB Connect to yyyyyy;

@

LIB Connect to zzzzzz;

IN x  Connection there are more than 10 database tables associated and 4 SQL statements.

In y Connection there are more than 10 database tables associated and 3 SQL statements.

In z connection there are 2 database tables associated and 1 SQL statement.

How many QVD files should I generate?

There are date fields in the tables which can be used for incremental Load.

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

It really depends on your data model and what you want to do with it.

Our main dash is a simple star schema so we have a single fact QVD and then a QVD for each dimension.

The Fact is incrementally reloaded and the dimensions are just reloaded in full.

However we then break the fact QVD down into smaller QVDs for use in lighter dashboards

View solution in original post

1 Reply
adamdavi3s
Master
Master

It really depends on your data model and what you want to do with it.

Our main dash is a simple star schema so we have a single fact QVD and then a QVD for each dimension.

The Fact is incrementally reloaded and the dimensions are just reloaded in full.

However we then break the fact QVD down into smaller QVDs for use in lighter dashboards