Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hii,
I am doing incremental load for one of the application.
All the data are coming from SQl database.
I have 3 tables on which I want to apply incremental load. So hat i have to do.
Wheather first store in QVD and then apply where exist on it or before storing it in QVD apply where exist on it.
while i am applying where not exist before storing it in QVD that is while loading from SQL function where not exist want work ?
so i am confused in it. can anyone can help me.
Hi Dhaval,
You Need to fetch only those records which are new. Then concatenate it with old Qvd and Then Store into qvd.
For reference : https://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
Thanks,
Arvind Patil
Hi,
First of all understand what is the process of the Incremental load basically it would be three types
1. Insertion Only
2. Insert, Delete Only
3. Insert, Delete and Update
Have on this threads
https://community.qlik.com/thread/84146
Regards
Anand