Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 ??