topic Relationships among data in QlikView https://community.qlik.com/t5/QlikView/Relationships-among-data/m-p/1216211#M863944 <HTML><HEAD></HEAD><BODY><P>"<STRONG style=": ; font-size: 12pt;">Given a data set, determine how the relationships among data will affect the QlikView data model (e.g., performance, accuracy</STRONG>)"</P><P></P><P>What this mean in qlikview certification.</P><P></P><P>experts please give me some sample, what they expect </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Relationships among data https://community.qlik.com/t5/QlikView/Relationships-among-data/m-p/1216211#M863944 <HTML><HEAD></HEAD><BODY><P>"<STRONG style=": ; font-size: 12pt;">Given a data set, determine how the relationships among data will affect the QlikView data model (e.g., performance, accuracy</STRONG>)"</P><P></P><P>What this mean in qlikview certification.</P><P></P><P>experts please give me some sample, what they expect </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Relationships-among-data/m-p/1216211#M863944 2020-11-25T16:16:04Z Re: Relationships among data https://community.qlik.com/t5/QlikView/Relationships-among-data/m-p/1216212#M863945 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">What this mean in qlikview certification.</SPAN></TD></TR></TBODY></TABLE></BLOCKQUOTE><P>It means you have to answer the question correctly or you won't get the points for it.</P><P></P><P>You have to understand why different actions have different effects on your data model with respect to performance, accuracy etc.</P><P></P><P>What happens when you join tables? Are there alternatives to joining tables? When would you use them? Why?</P><P>What is a synthetic key? Why is it created? Is it a problem? How can you prevent a synthetic key?</P><P>What is a cyclic reference? Why is it created? Is it a problem? How can you prevent it?</P><P>What is a slowly changing dimension? How can you handle a SCD in the model? What are the alternatives? Why would you choose one over the other?</P><P>When do you choose to concatenate tables? Why? What are the alternatives? What are the trade offs between them?</P><P>When would you use a Link table? Why? What are the alternatives?</P><P>...</P><P><EM>etc</EM></P></BODY></HTML> Wed, 21 Dec 2016 12:44:37 GMT https://community.qlik.com/t5/QlikView/Relationships-among-data/m-p/1216212#M863945 Gysbert_Wassenaar 2016-12-21T12:44:37Z