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

    Incremental load

    Renuka Sasikumar

      Hello,

       

      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.