topic Re: Only Updated data in QlikView

Only Updated data

dseelam — Fri, 18 Nov 2016 16:24:02 GMT

Hello All,

I am working on incremental loads on a view from oracle everything is working fine, Now I got a requirement asking to store history for that view , So I am storing a separate QVD for each day but hear am having a trouble duration of reload process became very slow as it is incrementing for each day and storing in separate QVD'S (IT HAS TO * ALL THE QVD'S for each day When incrementing) you can see in below picture how it is incremnting for each day

Is there any way that I can store the QVD's after 1st day only with incremental records instead of everything ??

Duration increase

Thanks,

Dinesh

Re: Only Updated data

vishsaggi — Fri, 18 Nov 2016 17:11:42 GMT

Read this and try ? If not can you share your script to look into?

https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/

Re: Only Updated data

dseelam — Fri, 18 Nov 2016 19:35:02 GMT

Hello Nag,

Thanks for replying my question is not about incremental load, It is about how to track history with incremental load ??