Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
April 13–15 - Dare to Unleash a New Professional You at Qlik Connect 2026: Register Now!
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

Only Updated data

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 ??

Test3.PNG

Duration increase

Capture.PNG

Thanks,

Dinesh

2 Replies
vishsaggi
Champion III
Champion III

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

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

dseelam
Creator II
Creator II
Author

Hello Nag,

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

Community Browser