1 Reply Latest reply: Nov 4, 2016 12:20 AM by Sushil Kumar RSS

    Incremental load for Insert and update , and also store historic data for 6 month only

    gaurav gopale

      Hi

       

      i have a fact table and i have to apply incremental logic for insert and update rows in fact table

      in such a way that it should  also store historic data for 6 months.

       

      Because , if i apply only insert and update incremental logic it will not store the historic data.

      I want historic data for only 6 months .

      ie if i load the data in junly month then it should store historic data only from jan to june.

       

       

      Can anyone help me in this.

       

       

      Thanks in advance