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 is a star schema?
How to handle multi value dimensions?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Why should we use data ware housing and how can you extract data for analysis with example?
What is Cognos script editor?
What are session timeout and application timeout? Where we have to do this process?
What is freehand sql?
I know of using applysimple, but there are other ways too?
if you use oracle sql*loader , how do you transform data with it during loading?
What are the differences between star and snowflake schema?
Explain the versions of reportnet?
Define Data Warehousing?
How we are using this function?
What does level of granularity of a fact table signify?
How to design file watch jobs?