topic Re: Preferred Underlying Data model in QlikView https://community.qlik.com/t5/QlikView/Preferred-Underlying-Data-model/m-p/353265#M131065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Always when possible star schema. Generally speaking it better to have bigger tables with less hops bewteen them rather than lots of small tables with lots of hops between them. Denormalization is quite usual in this cases.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 14 Jun 2012 14:28:54 GMT Miguel_Angel_Baeyens 2012-06-14T14:28:54Z Preferred Underlying Data model https://community.qlik.com/t5/QlikView/Preferred-Underlying-Data-model/m-p/353264#M131064 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>What is the preferred data model to be used in qlikview?&nbsp; </P><P>Is it better to have normalized table or de-normalized (star schema or snow-flake schema). </P></BODY></HTML> Thu, 14 Jun 2012 14:24:05 GMT https://community.qlik.com/t5/QlikView/Preferred-Underlying-Data-model/m-p/353264#M131064 2012-06-14T14:24:05Z Re: Preferred Underlying Data model https://community.qlik.com/t5/QlikView/Preferred-Underlying-Data-model/m-p/353265#M131065 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Always when possible star schema. Generally speaking it better to have bigger tables with less hops bewteen them rather than lots of small tables with lots of hops between them. Denormalization is quite usual in this cases.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Thu, 14 Jun 2012 14:28:54 GMT https://community.qlik.com/t5/QlikView/Preferred-Underlying-Data-model/m-p/353265#M131065 Miguel_Angel_Baeyens 2012-06-14T14:28:54Z