topic Synthetic Keys Best Practice in QlikView https://community.qlik.com/t5/QlikView/Synthetic-Keys-Best-Practice/m-p/736789#M1077803 <HTML><HEAD></HEAD><BODY><P>I've seen conflicting best practices regarding using Synthetic Keys.</P><P></P><P>One the one hand, <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4556">http://community.qlik.com/docs/DOC-4556</A> has a Development Checklist that starts with Synthetic keys removed from data model.</P><P></P><P>On the other, <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys">http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys</A> says Synthetic keys do not cause memory performance issues and are great.</P><P></P><P>What are your thoughts if you have the same set of multiple keys in 2+ tables?</P><P></P><P>What are the disadvantages to using synthetic keys?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 23 Jul 2014 20:43:00 GMT cbaqir 2014-07-23T20:43:00Z Synthetic Keys Best Practice https://community.qlik.com/t5/QlikView/Synthetic-Keys-Best-Practice/m-p/736789#M1077803 <HTML><HEAD></HEAD><BODY><P>I've seen conflicting best practices regarding using Synthetic Keys.</P><P></P><P>One the one hand, <A _jive_internal="true" href="https://community.qlik.com/docs/DOC-4556">http://community.qlik.com/docs/DOC-4556</A> has a Development Checklist that starts with Synthetic keys removed from data model.</P><P></P><P>On the other, <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys">http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/16/synthetic-keys</A> says Synthetic keys do not cause memory performance issues and are great.</P><P></P><P>What are your thoughts if you have the same set of multiple keys in 2+ tables?</P><P></P><P>What are the disadvantages to using synthetic keys?</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 23 Jul 2014 20:43:00 GMT https://community.qlik.com/t5/QlikView/Synthetic-Keys-Best-Practice/m-p/736789#M1077803 cbaqir 2014-07-23T20:43:00Z Re: Synthetic Keys Best Practice https://community.qlik.com/t5/QlikView/Synthetic-Keys-Best-Practice/m-p/736790#M1077804 <HTML><HEAD></HEAD><BODY><P>At the end of the second post even HIC says he would avoid synthetic key(its not recommended) and he explains why. Not sure where you got the message they are great <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Wed, 23 Jul 2014 21:07:08 GMT https://community.qlik.com/t5/QlikView/Synthetic-Keys-Best-Practice/m-p/736790#M1077804 2014-07-23T21:07:08Z