1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

Hi,

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

Thanks
S.A.K

Question Posted / laz

Answer Posted / laz

The answer is STAR SCHEMA . As, the data stored in
diamensional tables of the star schema is denormalized
hence it increases the space needed for storage of data.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we take backup when the database is opened?

594

What is the extension of file to save template?

580

Explain meta data?

552

What is a Decision Tree Algorithm?

4546

What is the working process for application.cfm?

544




What is data analysis?

540

What is data warehosuing hierarchy?

585

can anybody mail me the FAQS for hyperion essbase amd planning

5194

What are aggregate tables and aggregate fact tables?

530

What is the difference between star and snowflake schemas?

601

What are the advantages of raid 1, 1/0, and

533

How to define a cube??

550

What should I have in mind when building olap solution from scratch?

539

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

1734

Can a dimension table contain numeric values?

602