Interested to Buy Any Domain ? << Click Here >> for more details...
Which one among Star and snowflake schemas will occupy more
space?
- 1 Answers
- 8283 Views
- Barclays, I also Faced
- E-Mail Answers
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 batch processing?
How did you plan your Data ware house project?
Explain what is the difference between powerplay transformer and power play reports?
What is the difference between er modeling and dimensional modeling?
What is data mart in data warehouse?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between metadata and data dictionary?
Explain what is fact less fact table? Where you have used it in your project?
Explain what is difference between query studio and report studio?
What are the design methods of data warehousing?
What are the data marts?
What is the difference between data warehouse and operational systems?
What is metadata in context of a datawarehouse?
What is the difference between connected and unconnected stored procedures?
What is real-time datawarehousing?
