0 Replies Latest reply: Aug 5, 2016 3:06 AM by Sudha Eswaran RSS

    Incremental Load - Qlik Sense

    Sudha Eswaran

      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 database. 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.