0 Replies Latest reply: Dec 27, 2016 12:24 AM by Renuka Nadar RSS

    Incremental load

    Renuka Nadar



      Load * from xyz_2016_12 c

      inner join Table b on c.x=b.x

      where c.date>='2016-Dec-01' and c.date<'2016-Dec-26';


      Here my table name changes according to the month.

      For eg: jan = 01

                  feb = 02 .......


      I want to write incremental load for last two days, where I have to also see that my previous two dates including last month & current month.


      Like 02 jan 2017 if i am taking increment last two days will be 01 jan 2017 & 31 dec 2016


      Can anyone help on this.