--%>
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 : How are the sensory receptors

    According to the stimuli they assemble how are the sensory receptors categorized?

    		•
  • Q : Level of research - Taxonomy of

    Descriptive, conclusive and experimental reweave designs are used to study organizational behavior. Descriptive design illustrates how structure will be useful for researching a particular type of behavior, a conclusive research design cause and effect relationships. It predicts individual behavi

    		•
  • Q : Generation Y Define the term Generation

    Define the term Generation Y and their characteristics in Generation groups of Employees ?

    		•
  • Q : Define the term Infrastructure

    Infrastructure: The fundamental physical systems of a nation or business. Communication, transportation, sewage, water and electric systems are all illustrations of infrastructure. Such systems tend to be high-cost investments; though, they are vital

    		•
  • Q : Peripheral nervous system What do you

    What do you mean by peripheral nervous system (or PNS)? Answer: Peripheral nervous system comprehends the ganglia and nerves of the body.

    		•
  • Q : Human cells which generate proteins for

    Give some illustrations of human cells which generate proteins for exportation? Which cytoplasmic organelle is predicted to be well-developed and plentiful in such cells?

    		•
  • Q : Promotional Mix Define the term

    Define the term Promotional Mix and what are their roles. And explain why determination of promotional mix is important?

    		•
  • Q : What when I discover a tablet in my

    What when I discover a tablet in my stool?

    		•
  • Q : Function of plant cell wall Function of

    Function of plant cell wall: The plant cell wall has protective and structural functions. It plays a significant role in the constraint of cell size, preventing the cell to break whenever it absorbs lot water.   

    		•
  • Q : Are there living beings devoid of cells

    Are there living beings devoid of cells?

    		•