topic Re: hi in QlikView

hi

Wed, 13 Aug 2014 21:39:59 GMT

can anyone help me to find out the difference between the STAR SCHEMA and SNOWFLAKE SCHEMA.

Re: hi

ecolomer — Wed, 13 Aug 2014 21:54:04 GMT

You can see ...

Snowflake Schema vs Star Schema - Difference and Comparison | Diffen

Re: hi

ecolomer — Wed, 13 Aug 2014 21:54:43 GMT

more ...

Difference between Star & Snowflake Schema

Re: hi

MarcoWedel — Wed, 13 Aug 2014 22:06:12 GMT

star schema snowflake schema which schema usefull Qlikview?why ?

Re: Star schema or snowflake schema or flat file?

Star Schema

Star Schema or Snow Flaxe schema?

anybody knows what schema it is?

Re: Difference between Star Schema & Snow Flake Schema?

which schema is best for data modeling betwen star and snowflake?

Re: hi

ashfaq_haseeb — Thu, 14 Aug 2014 08:59:22 GMT

Hi,

Have a look at below posts

http://community.qlik.com/message/524541#524541

http://community.qlik.com/message/542932#542932

Regards

ASHFAQ

Re: hi

sujeetsingh — Thu, 14 Aug 2014 09:08:44 GMT

Marco, it is like you have given a lots of link for the concept..

Well go for the Ralph Kimbel data ware housing concepts.

It is the Black book for all such concepts.

Re: hi

SunilChauhan — Thu, 14 Aug 2014 09:12:29 GMT

snow flake star

1.Normalize denormalized

2.fact-> dimension-> dimension fact-> dimension (centralized fact)

3.when select to find result when select to find take shortest path( retrival faster)

may take more time( comparatively slow

retrieval)

4. more Ram Consumption comparative less Ram

5. No duplicates duplicated data posiblility as merging tables

6. query response time is more comparitavely less

7. good for transaction dbs Good for BI (where only select impressions)

Re: hi

Thu, 14 Aug 2014 13:01:04 GMT

Please search in Google, you will enough material.

Hope by above answers your query is sorted.

Thanks!