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.