--%>

Surrogate keys

Why surrogate keys are used?

E

Expert

Verified

a) Data tables in the various source systems can use several keys for same entity.

b) Keys may change or be reused within the source data systems.

c) Alterations within the organizational structures can move keys in hierarchy.

   Related Questions in Biology

  • Q : Adult and human fatal circulation

    Concerning the mixture of arterial with venous blood state the difference between the adult circulation and the human fatal circulation?

  • Q : Describe the function of immune system

    Describe the function of immune system?

  • Q : Key Concept of Different Views of

    The concepts for developing these different views of organizational learning come primarily from three sources: 1) The articles the authors see an organization as a culture and the juxtaposition of order and disorder often stimulates learning. 2) The social construction of knowled

  • Q : Representatives of platyhelminth phylum

    Write down the best known representatives of the platyhelminth phylum?

  • Q : Orders of placental mammals What are

    What are the major orders of placental mammals? Describe some representative species and distinguishing characteristics of each of such orders?

  • Q : Other Factors - Personality

    I. Temperament: Temperament and other non-intellectual personality traits are distributed according to the normal distribution. Temperament  is the degree to which one responds emotionally. II. Interest: The individual normally has many interests in

  • Q : What is order and rejection reasons

    Order reasons and Rejection reasons: Example Order reason can be utilized for sample products, free goods and best price discounts and at the similar time rejections can utilized mostly for discard the documents and also in the case of CR, DR.

  • Q : Discrimination-Barriers to Diversity-

    Barring an individual from membership of an organization or from a job because of his or her membership of a particular group. An example of unfair discrimination is the company that only interviews men for a position that requires a lot of travel.  

  • Q : Route of nutrients after digestion From

    From intestinal lumen through to tissues - Explain the route of nutrients after they get digested?

  • Q : Types of circulatory systems Describe

    Describe the two types of circulatory systems? Answer: The circulatory systems can be categorized into closed circulatory system and open circulatory system.