topic Re: why Should love it in Synthetic Key? in QlikView

why Should love it in Synthetic Key?

Wed, 02 Apr 2014 18:46:19 GMT

Hi QV Experts,

1.What is a synthetic key? - I am idea about synthetic key but please help me below two QS?

2.When you are (they) acceptable, why ?

3.And when should they be avoided? why ? (why Should love it in Synthetic Key ,it is give any memory consume)?

Regrads,

Raja.

Re: why Should love it in Synthetic Key?

Nicole-Smith — Wed, 02 Apr 2014 18:48:13 GMT

Henric Cronström explains it well in this blog post: http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys

Re: why Should love it in Synthetic Key?

fkeuroglian — Wed, 02 Apr 2014 23:38:29 GMT

Hi, see the attached.

hope this help

Fernando

What is Synthetic Key?

Synthetic keys in Qlikview - YouTube

Re: why Should love it in Synthetic Key?

Thu, 03 Apr 2014 04:18:58 GMT

Hi,

Thanks to all,

When should you are acceptable Synthetic Key, why ?.

Regards,

Raja.

Re: why Should love it in Synthetic Key?

tresB — Thu, 03 Apr 2014 04:24:11 GMT

Go through this link (one of the best discussions in this forum I believe) : Re: Should We Stop Worrying and Love the Synthetic Key?

Re: why Should love it in Synthetic Key?

Thu, 03 Apr 2014 04:31:22 GMT

Hi Tresesco,

Yes, it is good discussion about synthetic key is acceptable.but i am little bit confusion, please help me short explanation..with example.

Regards,

Raja.

Re: why Should love it in Synthetic Key?

tresB — Thu, 03 Apr 2014 04:49:20 GMT

Please have patience to go through the thread carefully, explanations are there with examples; specially concentrate on the responses by John Witherspoon there.

Re: why Should love it in Synthetic Key?

nizamsha — Thu, 03 Apr 2014 05:11:12 GMT

if two column or more same column present in different table then synthetic keys will occur

to avoid this u can use alias or qualify or comment the unwanted column this is one of the way to avoid synthetic keys

in interval match synthectic keys will come but there wont be any issue while using interval match

Re: why Should love it in Synthetic Key?

its_anandrjs — Thu, 03 Apr 2014 05:59:27 GMT

When ever you read the tables in qlikview inside qlikview function it identify the same field name in different table if they appears then a synthetic table is maintain with key on the synthetic tables.

It is good that qlikview automatically identify the fields and maintain table but if there is many fields and when you reload your application some time qlikview takes much time to load or some times hang. So here we need to avoid and maintain composite keys for this.

Hope this helps