incremental load and data reloading

[#1]

Hi All,

I have one field which contains years from 2010 to 2019, If it is current year then we should do incremental load otherwise it should do full load.But my Fiscal year start from October, If it is current year we should load last two months data. If October and November data are there in QVD then we should delete the current and previous month data (Dec & Jan) and again load the Dec & Jan and append to previous data (Incremental load).

Could you please help me on this with example?

Thanks,

M V

[#2]

Hi Guys,

Any ideas on this? Please help me on this.It's an urgent requirement.

Thanks,

M V

[jagan]

Hi,

You need to create a Fiscal Calendar, check this file

Fiscal and Standard Calendar generation

Regards,

Jagan.