5 Replies Latest reply: Jul 22, 2014 2:01 PM by Srikanth P RSS

    Incremental Load

      Hi all,

       

      can anybody clear my doubt on Incremental load with "Insert ,Update and Delete" concept, i have done all the concepts of incremental load (Insert only,Insert and Update,Insert ,Update and delete)

      I have followed these steps to complete this

       

      Process1:

      1.Loading initial data into the qlikview app

      2.storing data into QVD file

      3.Finding max date from the existing QVD (on initial data)

      4.fetching data from data source on max date

      5.concatenating new records with existing records

      6.finally updating QVD with all records

       

      for Delete,

       

      i have added the below step

      7. performed Inner join on the actual data source with updated QVD.

      so it has completed my task end to end for "Insert,Update and Delete" functionality.

      but, i have raised with a doubt in myself that , why we need to follow step by step as described above to fetch (New ,Updated and Deleted) data into the QVD.

      can't we go with the below steps instead of following all 7 steps :

       

      Process 2:

      1.Loading initial data into the qlikview app

      7. performed Inner join on the actual data source with either from QVD/Initial data source.

       

      Is there any difference would be done from Process 1 to Process 2

       

      Thank you,

      Charitha.