Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
What is the best practice of creating a data model from the beginning?
Below is my current flow of creating data model:
Please advise if i would like to improve the performance of Qlikview project.
Many Thanks.
Best Regards,
Louis
Till here, we are in good work. But, After that you may remove Synthetic keys and Ref loops if any. Then, Business facts and transaction dimensions may understand to QIX engine.
Hi Louis,
Below is the practice i am following.
QlikView first extract load and transform the data on INLINE memory (RAM). So the creation of QVD and loading the QVD data again is a loss of time according to me.
In case if you really need the QVD files then create after transforming data.
Thanks,
Varun.
Hi Varun,
If i need to to use incremental load,
does qvd file is a must in this case?
If yes, what is the best flow?
Best Regards,
Louis
Hi Louis,
Try to create data model in seprate qvw as well as follow below steps which mentiend above:
Thanks,
Arvind Patil
For Incremental Load,
You can alter your approach based on the scenario you are on.
Kindly refer the attached document.
Credits to the Original author of the Document
Thanks,
Varun