Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Henric Cronström explains it well in this blog post: http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys
Hi, see the attached.
hope this help
Fernando
Hi,
Thanks to all,
When should you are acceptable Synthetic Key, why ?.
Regards,
Raja.
Go through this link (one of the best discussions in this forum I believe) : Re: Should We Stop Worrying and Love the Synthetic Key?
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.
Please have patience to go through the thread carefully, explanations are there with examples; specially concentrate on the responses by John Witherspoon there.
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
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