topic denormaization in QlikView https://community.qlik.com/t5/QlikView/denormaization/m-p/258591#M1184156 <HTML><HEAD></HEAD><BODY><P> ok thank u kamal..............</P></BODY></HTML> Thu, 20 Oct 2011 11:48:10 GMT 2011-10-20T11:48:10Z denormaization https://community.qlik.com/t5/QlikView/denormaization/m-p/258589#M1184154 <HTML><HEAD></HEAD><BODY><P>tables linked in qlikview application are normalized or denormalized??? and how???</P></BODY></HTML> Wed, 19 Oct 2011 05:34:46 GMT https://community.qlik.com/t5/QlikView/denormaization/m-p/258589#M1184154 2011-10-19T05:34:46Z denormaization https://community.qlik.com/t5/QlikView/denormaization/m-p/258590#M1184155 <HTML><HEAD></HEAD><BODY><P>Tables in qlikview are denormalised.......</P><P>First of all what is normalization</P><P>Normalization---Normalization is generally used in relational database for reducing the redundant(repeated)&nbsp; and consistency.It i used to organize data.for example when you are using Employee table with the address table ,when you want to see the address,same as for city ,and other fields.</P><P></P><P>Some of disadvanatge of normalization are...</P><P>1&gt;It is slow</P><P>2&gt;The more your data is normalized the more are the no of joins</P><P>3&gt;When we use denormalization we don't have to write complex queries.</P><P>That is why we prefer denormalization</P></BODY></HTML> Thu, 20 Oct 2011 10:28:04 GMT https://community.qlik.com/t5/QlikView/denormaization/m-p/258590#M1184155 kamalqlik 2011-10-20T10:28:04Z denormaization https://community.qlik.com/t5/QlikView/denormaization/m-p/258591#M1184156 <HTML><HEAD></HEAD><BODY><P> ok thank u kamal..............</P></BODY></HTML> Thu, 20 Oct 2011 11:48:10 GMT https://community.qlik.com/t5/QlikView/denormaization/m-p/258591#M1184156 2011-10-20T11:48:10Z