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 |
Explain in detail abt measure objects? And what is the use of it? How to create it?
Can we have multiple application.cfm file in an application?
How can you set the session management?
What is the goal of optimizer?
How to create context?
How do you setup Lo-cockpit?
what is difference between drill & scope of analysis?
what are different storage options supported by oracle ?
What is data warehosuing hierarchy?
What is an er diagram?
Store (and count) non-fact records?
What is dimension modeling?