4 Replies Latest reply: Mar 14, 2018 5:02 AM by Stefan Wühl RSS

    What is best reload strategy for Incremental load?

    Rahul Pawar

      Hello All,

       

      Trust that you all are doing well!

       

      At present I have two QVW files to fulfill the incremental load requirement:

      1. History.qvw – It will fetch entire data from the source system and dump it into QVD file.
      2. Delta.qvw – It will fetch only the changed data during last 30 days and dump it into QVD file.

       

      What could be the best reload strategy? How many tasks we have create? What would be the ideal time of task execution (Ideally, it should be during offline hours)? What could be the frequency of each task?

       

      Looking forward to get more inputs on this.

       

      Regards!

      Rahul Pawar