Incremental load and monthly load

Tue, 23 May 2017 11:50:28 GMT

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

Re: Incremental load and monthly load

vikasmahajan — Tue, 23 May 2017 11:53:19 GMT

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

Vikas

topic Re: Incremental load and monthly load in QlikView

Incremental load and monthly load

Re: Incremental load and monthly load