Qlikview on star schema

[#1]

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

[daveamz]

Hi,

See this: http://community.qlik.com/docs/DOC-4556

Regards,

David

[its_anandrjs]

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

[jagan]

Hi,

Qlikview works better in Star Schema, because number of joined will be reduced during the runtime.

Regards,

Jagan.

[vardhancse]

In QlikView 11 for Developers we can see all the best practices in data model.

[sujeetsingh]

Follow my post

Best Practices for Data Modelling

[daveamz]

Not always. Most of the times, yes, but not always. It depends on your data.

[jagan]

Hi,

Check this image for comparison between various schemas

Jagan.