topic Re: Denormailizing for performance in QlikView https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803362#M283611 <HTML><HEAD></HEAD><BODY><P>the single table data model provide an excellent response time (faster than star and snowflake) however it consumes a lot of RAM and other system resources, i personally would recommend the star schema data model on the single table.</P></BODY></HTML> Fri, 16 Jan 2015 14:25:39 GMT maleksafa 2015-01-16T14:25:39Z Denormailizing for performance https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803360#M283609 <HTML><HEAD></HEAD><BODY><P>Is Single table data model is the most efficient in qlikview ? If it is true please explain .</P><P>What are the Steps to make single table datamodel in qlikview ?</P><P></P><P></P><P>Thanks</P></BODY></HTML> Fri, 16 Jan 2015 12:47:46 GMT https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803360#M283609 Anonymous 2015-01-16T12:47:46Z Re: Denormailizing for performance https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803361#M283610 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>Typically a single-table data model in QlikView is implemented loading your fact table first and JOINing your dimensions tables afterward. The type of JOIN best suited for the task (INNER, LEFT, RIGHT, OUTER) will depend on your data.</P><P></P><P>Kind Regards.</P></BODY></HTML> Fri, 16 Jan 2015 13:05:58 GMT https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803361#M283610 consenit 2015-01-16T13:05:58Z Re: Denormailizing for performance https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803362#M283611 <HTML><HEAD></HEAD><BODY><P>the single table data model provide an excellent response time (faster than star and snowflake) however it consumes a lot of RAM and other system resources, i personally would recommend the star schema data model on the single table.</P></BODY></HTML> Fri, 16 Jan 2015 14:25:39 GMT https://community.qlik.com/t5/QlikView/Denormailizing-for-performance/m-p/803362#M283611 maleksafa 2015-01-16T14:25:39Z