Which one among Star and snowflake schemas will occupy more
space?
Answer Posted / kiran
Star Schema will occupy more space since the tables are in
demoralized form and will have many historical records with
redundant information on some columns of the table. Hence
require more storage space.
| Is This Answer Correct ? | 25 Yes | 6 No |
Post New Answer View All Answers
Can any one explain the hierarchies level data warehousing.
Code the tables statement for a single-level (most common) frequency?
What is vdl (view definition language) explain?
What is incremintal loading?
What is surrogate key? Where we use it explain with example?
Explain why fact table is in normal form?
What is data stream and data adaopter?
Where the applications and where
what are different storage options supported by oracle ?
What is the difference between Datawarehouse and OLAP?
Explain how to generate iqd file from framework manager?
What are the types of SCD?
Explain what is the metadata extension?
What is prompt types of prompts?use of prompts syntax of prompt?
What is degenerate dimension table?