Incremental load and monthly load

[#1]

Hi All,

I have a scenario where i am using Incremental load in my script and it is working fine.

Now i have a requirement that some of the data which was not captured earlier during daily load(late arrived) can also be there in the database.

So what we are planning to do is ,i ll load the data again for a month,since i am using incremental load in my script it will load only the data which is greater than the max date,in this case if i load the entire month data again it will not be captured in my application.

My requirement is daily it should be a incremental load but in every 10th of next month the entire data of previous month has to be loaded again.

How can i achieve this?

Please provide your suggestions.

Thanks in advance!

Best Regards,

Reena

[vikasmahajan]

if you are using excel files you can check time stamp  and achieve the same like this Incremental Load using Timestamps Multiple Excel

Vikas