hi all
i have daily incremental data from hive, i need to load the present month and last month data in qvd with a condition as i dont have a date field i just have a year and month field.
condition:
if month(current date -15) = last month then load last month and present month data
else if month(current date -15) = current month load only current month data.
this should apply even if the year change happens. I am having issue with year change and this year is 2020 i had the script working till dec 2019. Please give a solution as soon as possible
thanks