Discussion board where members can get started with QlikView.
I want to know if there are best practices from the perspective of designing qlikview model on a data mart built at SQL Server.
Is it suggested to create an denormalized flat table at Qlikview?
Kindly provide feedback on it.
See this: http://community.qlik.com/docs/DOC-4556
You can read some of this documents also
The Optimal QlikView Data Structure
Star Schema or Snow Flaxe schema?
What is Star schema in qlikview?
Qlikview works better in Star Schema, because number of joined will be reduced during the runtime.
In QlikView 11 for Developers we can see all the best practices in data model.
Follow my post
Best Practices for Data Modelling
Not always. Most of the times, yes, but not always. It depends on your data.
Check this image for comparison between various schemas