topic Synthetic Tables? in QlikView

Synthetic Tables?

Wed, 17 Jun 2015 18:02:45 GMT

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.

Re: Synthetic Tables?

robert_mika — Wed, 17 Jun 2015 18:16:54 GMT

Synthetic Keys

Re: Synthetic Tables?

Wed, 17 Jun 2015 19:53:34 GMT

Thanks Robert.

Re: Synthetic Tables?

Greg_Williams — Wed, 17 Jun 2015 20:04:35 GMT

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

Re: Synthetic Tables?

Wed, 17 Jun 2015 20:10:52 GMT

Thanks Greg.

Re: Synthetic Tables?

Greg_Williams — Wed, 17 Jun 2015 20:30:41 GMT

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

Thanks. Enjoy Qlik!

-Greg