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 : Ingestion of alcohol raise diuresis Why

    Why does the ingestion of alcohol raise diuresis? Answer: Alcohol hinders the secretion of ADH (that is, antidiuretic hormone) by the pituitary. That is why whenever

  • Q : What is Safety Management Safety

    Safety Management: It is an integral part of an organization's responsibilities, as it exhibits the company's commitment to the welfare of its staff. The approach to an organization takes to implement safety management strategies differ depending on t

  • Q : Main kinds of viral hepatitis Write

    Write down the three main kinds of the viral hepatitis?

  • Q : How synaptic transmissions among

    How synaptic transmissions among neurons occur?

  • Q : Commercial websites Determine which of

    Determine which of the given are commercial websites?a) Search portals  b) Press releases  c) Product specifications  d) Customer service. Help me in determing the right answer.

  • Q : What do you mean by the term haptens

    What do you mean by the term haptens? Illustrate briefly with an example?

  • Q : Perceptual mechanism-throughputs of the

    What is the meaning of Perceptual mechanism or throughputs of the perceptual procedure? Briefly describe it.

  • Q : Uncontrolled mitotic process Name the

    Name the uncontrolled mitotic process which takes place as disease in the pluricellular beings termed?

  • Q : Describe the group of the phylum

    Describe the group of the phylum Chordata which first colonized the terrestrial atmosphere? From which habitat did phylum Chordata come?

  • Q : Describe employees responsibilities

    Employees responsibilities towards company: As an employee you have many responsibilities to your employer. They are as: to perform a good day’s work to be loyal to work as part of the team to value the relationship to earn the employer’s

©TutorsGlobe All rights reserved 2022-2023.