Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Synthetic Tables?

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.

Tags (1)
5 Replies

Re: Synthetic Tables?

Not applicable

Re: Synthetic Tables?

Thanks Robert.

Employee
Employee

Re: Synthetic Tables?

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!!!

-GW

Not applicable

Re: Synthetic Tables?

Thanks Greg.

Employee
Employee

Re: Synthetic Tables?

Glad to help. Please consider marking the inquiry Answered or refine your question for further assistance.

Thanks. Enjoy Qlik!

-Greg