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.