Which one among Star and snowflake schemas will occupy more
space?
Answer / 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 |
What is difference between Business Objects and Hyperion Essbase? Please help me
Difference between cold fusion 5 and cold fusion mx 6?
What are the fundamental elements of the data warehouse?
When should one use an MD-database (multi-dimensional database) and not a relational one?
Explain what are the methodologies of data warehousing?
How to get the first 100 rows from the flat file into the target?
Difference between PowerPlay transformer and power play reports?
what is difference between scd2 and scd3
What are session timeout and application timeout? Where we have to do this process?
What is the difference between junk dimension and degenerated dimension?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?