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 are data mart and dwh normalized or denormalized? Do both of them exist in
Explain Association algorithm in Data mining?
What is factless fact tables?
What is degenerate dimension table?
Which kind of index is preferred in DWH?
Explain what is a cube in data warehousing concept?
Why fact table is in a normal form?
What is Cognos script editor?
what is a hot file, why we need in datawarehousing, where we used in general
What is Time Series algorithm in data mining?
Explain where do we use semi and non additive facts?
Explain why are oltp database designs not generally a good idea for a data warehouse?