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 |
How can we determine what records to extract?
Which one among Star and snowflake schemas will occupy more space?
Explain what are fact, dimension, and measure?
what is parallel query?
if you use oracle sql*loader , how do you transform data with it during loading?
What is Conceptual, Logical and Physical model?
Explain meta data?
What is data validation strategies for data mart v?
What is the "junk dimension"? Give with examples?
Explain what are the different types of join operations?
What is the function of etl when used in data warehousing?
Fact table is in normalized or de-normalized form?