Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Thank you.
Sincerely,
Harshraj Sanghvi
Hi,
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?
Regards
Anand
Hi,
Qlikview works better in Star Schema, because number of joined will be reduced during the runtime.
Regards,
Jagan.
In QlikView 11 for Developers we can see all the best practices in data model.
Follow my post
Not always. Most of the times, yes, but not always. It depends on your data.
Hi,
Check this image for comparison between various schemas
Jagan.