Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a QlikView application which loads the data from a
oracle database...
SELECT * FROM DB."DATE_DIMENSION";
Is there a way to do an incremental update of the data (only reload new data)
without loading the entire data of the db.
How is it possible...?
Hi Rob,
Can you please attach any sample application which does he incremental load please.
Rikab Kothari wrote:Can you please attach any sample application which does he incremental load please.
There is an example in the Qlikview Cookbook.
-Rob
Hi Rob,
Here is the attached application for incremental load. plz find it.
Hope it will solve your problem.
Thanks
Neetu Singh
Hi Neetu,
It was not Rob. It was me who was looking for the incremental reload.
Anyway many thanks for sending me the application. Hope it is understandable and can use the same logic in my document. Because I have few document which does the incremental load but I couldn't understand how it was done. Hope your document will be understandable.
Rikab Kothari wrote: It was me who was looking for the incremental reload
Hi Rikab,
There is another example in the Qlikview Cookbook that takes a slightly different approach then Neetu's example. You can download the Cookbook from
http://robwunderlich.com/Download.html
-Rob
Hi Rob,
Thanks for reply! Yes I already gone through that. But not able to understand how it works. If I don't understand then it not easy to apply the same logic in my document also.
May be I need to dig little deeper to find out how exactly it is happening there. I will definitely go through it once more then will let you know the outcome. Again many thanks for your concern!
Hi Rob and All(Who are all is involved in this post),
I have attached very basic document to work on with incremental load. Can some one please do the incremental load with that so that I can understand the basic things in that.
It is very small and it will not take much time to work on it.
Hope to receive reply from some one soon.
Hi All,
Can some one please work on in my document and help me out!
Thanks and Regards,
Rikab Kothari
Hi All,
Can some please help me out to do the incremental load for the document which is attached just for the understanding purpose. I have been waiting for the long time but still there is no response.
Hi Rikab,
Please find the attached application for incremental load. hope it will helpful to you.
If any issue . Plz feel free to coordinate with me,
Bye nd Take Care
Neetu Singh