Question
What are the advantages and disadvantages of star and snowflake schema?
Answers
Star Schema Advantages: Reduces the number of joins between the tables and hence faster performance.
Star Schema Disadvantages:Requires Most amount of storage space.
Snowflake Schema Advantages: Minimum storage space and minimum data redundancy.
Snowflake Schema Disadvantages:Requires more joins to get information from look up tables hence slow performance.   Your Comment




  • Contributors: *,


Search
Can you Answer!!
  • Q Explain techno-fossils.
  • Q What set of skills required to become a social media manager?
  • Q Are there any facilities for having backup in ireport?
  • Q How do you depict an ip address?
  • Q Do you know the difference between shares and debentures?
  • Q      What information is required when TCP/IP is configured on Window Server?
  • Q Write Notes on ISSR
  • Q Write briefly about each of the following Accumulator Register
  • Q A small worm which lives in ponds and rivers and sucks the blood of animals is?
  • Q What are "c" and "b" permission fields of a file?
  • Q Alpha-keratin is a protein present in which thing?