Preferred Underlying Data model

[#1]

Hi All,

What is the preferred data model to be used in qlikview? 

Is it better to have normalized table or de-normalized (star schema or snow-flake schema).

[Miguel_Angel_Baeyens]

Hi,

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.

Hope that helps.

Miguel