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
What is the difference between Datawarehouse and OLAP?
what is user variable in affinium campaign? and some real time examples.
How do you create surrogate key using ab initio?
What are the different types of join operations?
Explain what are data marts?
What is data stream and data adaopter?
Explain what is metadata reporter?
What are non-additive facts in detail?
What is pre-emptive and non-pre-emptive?
What is execution plan?
What is the limit to the number of sources and targets you can have in a mapping?
I need to set predefined condition. How I do this?
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?
Why we use repository connectivity?
What is the difference between data warehouse and operational systems?