My Qlikview application is getting bigger day by day as we load every month in QVD's.
I have data coming from Excels/Oracle/SQL and 6 months back the loading time was 30 min now it become 1hour 35 min.
Could you please suggest the best approach for loading data?
Will it be good if we separate backend(scripts) and front end Dashboard and load data through binary load?
Best Approach to Load Data:
Incremental Loads but Total Loads When needed
To the last question obviously Yes!