10 Replies Latest reply: Nov 23, 2015 4:01 AM by Tatsiana Chetirbok RSS

    incrmental load

    kumar avisakula

      Hi

      I have a requirement like below. I have an QVD which is 3 months data till yesterday and daily I will get an excel file as a data and it will be override on daily base with the new data. Now here is situation for me

       

      I want  add data to existing QVD with the new data on daily basis.Suppose if I get an excel data today, it has to check November month QVD data and with ID columns(there time stamp or modified date column) and replaced with new data. In the same way if I run this load on December it has to check only December data and modified with excel data.

       

      Here I don't have time stamp column and only having ID column

       

       

      Please suggest me how to proceed on this.

       

      Regards,

      Kumar