I have incremental data with only month specified. I need to delete the last 30 days data and update all the data including present date.
lets say i have data till today(2019/09/11). As i dont have the date specified and its last 30 days data to be deleted and updated. If the present date is <30 i need to delete the last month data till present data and update till present date again.
but i don’t have the order date in my table i only have the month. So if its 15 of this month and if i load the data tomorrow it should delete last months and present month data and load all the data till tomorrow as the data would change depending on the trigger 30 days /20 days