--%>

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 : Why visual images are projected in an

    Since the visual images are projected in an inverted way on retina why don't we see things reversed?

  • Q : Cartilaginous and osseous tissue Which

    Which type of tissue is cartilaginous and osseous tissue?

  • Q : State Inventory Planning Inventory

    Inventory Planning: It is the process of determining the optimal quantity and timing of inventory for the aim of aligning it with production and sales capacity. Inventory planning has a direct impact on company's cash flow and gain margins particularl

  • Q : Explanation of concentration

    Give a brief explanation of concentration gradient? Is it correct to refer to ‘concentration gradient of the water’?

  • Q : Constiutuent of air Specify the

    Specify the constitution of the air before the life of originon the earth?

  • Q : Mechanisms by which the pathogenic

    Name some mechanisms by which the pathogenic bacteria cause diseases? Why is this knowledge significant?

  • Q : Define Outsourcing Outsourcing : It is

    Outsourcing: It is any task, operation, job or process which could be performed by staff within an organization; however is rather contracted to a third party for a significant time period. In addition, the functions which are executed by the third pa

  • Q : Function of cholecystokin in the

    How cholecystokin is produced and what is the basic function of cholecystokin in the digestive process?

  • Q : Traits Characterstics of

    Personality traits are enduring characteristics that describe and individual's behavior. The more consistent the characteristic and the more frequently it occurs in diverse situations, the more important that trait is in describing the individual. Several attempts have been made to isolat

  • Q : Protective structures of the central

    Describe the protective structures of the central nervous system existed in vertebrates?