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 reference cursor?
What are data validation strategies for data mart validation after loading process?
What is the very basic difference between data warehouse and operational databases?
What is data stream and data adaopter?
What is dimensional modelling?
What is the use of incremental aggregation? Explain me in brief with an example?
Give some difference between oltp and olap.
What are the tools available for etl?
3.What is fact less fact ?
9 Answers Accenture, HCL, TCS,
What is the main difference between star and snowflake star schema? Which one is better and why?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
What are different stages of ?Data mining??