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.
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!!!
.png "Former Employee"){kind=icon}