Incremental load and monthly load

Report Inappropriate Content · ‎2017-05-23

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 · ‎2017-05-23

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Related Topics