--%>
Assignment Help - homework help

Starschema and snowflake schema

When should a star schema be used and when a snowflake schema should be used, explain in brief?

E

Expert

Verified

A star schema refers to a simplest data warehouse schema. Snowflake schema is same as that of the star schema. It generally normalizes the dimension table in order to save the data storage space. It may be used in order to represent the hierarchies of the information.

   Related Questions in Biology

  • Q : Types of fecundation in arthropods What

    What are the various types of fecundation which take place in arthropods? Also describe the predominant type?

    		•
  • Q : In which subphyla are the

    In which subphyla are the protochordates separated? Write down some representatives of each protochordate subphylum?

    		•
  • Q : How can endoskeleton of echinoderms be

    How can endoskeleton of echinoderms be characterized in the comparison of analogous structures existed in arthropods, vertebrates, and molluscs?

    		•
  • Q : Utilization of Trading Partner in GL

    Utilization of Trading Partner in GL account: It is utilized for consolidation. Each of your transaction which you perform with your partner/sister/holding company required to have a trading partner. Therefore, if you contain a particulate G/L account

    		•
  • Q : Evolutionary theories Historically what

    Historically what were two major evolutionary theories?

    		•
  • Q : Explain Advent of Electronic

    Advent of Electronic Communications: In the late ‘90s, a new means of communication was discovered - the electronic medium. The electronic technology of communication transformed the workplace. Though the advantages are numerous

    		•
  • Q : Determining Cost of goods manufactured

    1. Reader's Corner is a small book store that rents space in a neighborhood shopping mall for $19,200 a year.  Utilities add another $7,800 yearly.  The total staff salaries and benefits projected for next year equal $56,000.  Also, Readers Corner spend

    		•
  • Q : Define Marketing Management Marketing

    Marketing is a process in a social system  by which tlie demand pattern for product and services can be anticipated, enlarged, created and satisfied tlirougli tlie conception,  production, promotion and physical distribution of goods a

    		•
  • Q : Hyphae and mycelium of the

    Describe what are hyphae and mycelium of the pluricellular fungi?

    		•
  • Q : What do such sacs do What do such sacs

    What do such sacs do?

    		•