Denormailizing for performance

[Anonymous]

Is Single table data model is the most efficient in qlikview ? If it is true please explain .

What are the Steps to make single table datamodel in qlikview ?

Thanks

[consenit]

Hi there.

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.

Kind Regards.

[maleksafa]

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.