Hi star schema takes more space then the snowflake because star schem

Hi,

Could any one tell me which schema (star and snow flake
schema) will take much space?

Thanks
S.A.K

Question Posted / prasant tripathy

Answer Posted / prasant tripathy

Hi

star schema takes more space then the snowflake because
star schema is denormalised schema and snowflake is
normalised

Is This Answer Correct ?

10 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

1118

Which are the olap tools available that are supported by oracle?

884

What is the difference between olap and datawarehosue?

897

What is Sequence clustering algorithm?

1966

How to create diff. Types of templates?

983

What is the purpose of cluster analysis in data warehousing?

946

Explain difference between snow flake and star schema.

962

Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?

988

How to create context?

953

Explain what does level of granularity of a fact table signify?

903

What are the fundamental elements of the data warehouse?

935

Explain degenerate dimension table?

986

How can we schedule the graph in unix?

934

Explain difference between data ware house & data mart?

931

Do you view contain data?

885