Discussion board where members can get started with QlikView.
I am new to QlikView and little confused of Synthetic Table. Can any one explain me what are the disadvantages of having Synthetic Table and what are the advantages after removing Synthetic Tables from data model.
Thanks in Advance.
Robert has already provided the description. In short:
1. Less confusing model
2. Potential performance improvement when loading records into QV Server (computer's) RAM and shorter CPU processing
3. Potential removal of erroneous aggregations (I.e. "bad calculations")
* In some situations, Synthetic keys are not always "bad". Simply depends on the data modeling situation in combination with desired performance requirements (or expectations).
Hope this helps out! Welcome to Qlik - it's an awesome data analytics solution!!!
Glad to help. Please consider marking the inquiry Answered or refine your question for further assistance.
Thanks. Enjoy Qlik!