--%>
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 : Individual Behavior - Organizational

    The meaning of this behavior is related to some concrete action by a person. For instance, how a teacher behaves in the class reflects his behavior.  The behavior of an individual is influenced by various factors. Some of the factors lie within himself, for example, his instincts, personalit

    		•
  • Q : What is xaxim What is meant by the

    What is meant by the xaxim?

    		•
  • Q : Elucidate the word polyembryony

    Elucidate the word polyembryony?

    		•
  • Q : Reason for Group Formation -

      There is no single reason why individuals join groups. Since most people belong to a number of groups, it is obvious that different groups offer different attractions and benefits to their members. The most popular reasons for joining a group is related to our needs for security, s

    		•
  • Q : What is Proactive Leadership Proactive

    Proactive Leadership: It is a function, not a position. This is a composite of all of the skills a person exerts that influence and motivates others to think, say and do the right things to attain the worthwhile vision, leading operating values, missi

    		•
  • Q : Share of a subsidy which benefits

    The burden of a tax is shared through producers and consumers. Under what conditions will consumers pay most of the tax? Under what circumstances will producers pay most of it? What determines the share of a subsidy which benefits consumers?T

    		•
  • Q : Define the term proteinuria Define the

    Define the term proteinuria? Describe why proteinuria is a sign of glomerular renal injury?

    		•
  • Q : Consequences of shifting the chemical

    Explain the consequences of shifting the chemical equilibrium of formation of bicarbonate from carbon dioxide and water towards the consumption of products of reverse reaction?

    		•
  • Q : Modes of transmission-main

    What are the modes of transmission, main signs and symptoms and treatments of hepatitis C?

    		•
  • Q : Define Operating Leadership Operating

    Operating Leadership: It identifies key risk factors which affect individual and team performance. This has been specifically designed to give the National Park Service with a standardized approach which will aid employees in assessing and managing ri

    		•