17 Replies Latest reply: Jun 5, 2017 12:05 AM by ar eiuiew RSS

    Incremental load by using qvd date

    khalander kandukrui

      Hi Everyone,

       

      I have one requirement like system has to do incremental process based on date in particular qvd

      For Example. I have source file like

      IDNameDate
      1A01/01/2016
      2B31/01/2016
      3C01/02/2016
      4D24/02/2016
      5E01/03/2016
      6F15/03/2016

       

      Requirements:

      1) Store the month wise data into particular month qvd like jan data into X_012016.qvd, Feb data into X_022016 and so on.

      2) Now i need to write one for loop like system has to check the dates in oldest qvd first( in our case Jan month qvd) and then it should do incremental process( Insert or update) from DB and jan qvd should contains updated jan data. and it has to check for all qvd and hs to update data for all month qvds.

       

      Kindly do the needful