none
surrogate key RRS feed

Answers

All replies

  • Google/Bing "surrogate key" for plenty of resources to answer your question.

    It is commonly used to generically reference an entity such as a customer.

    Rather than using a customer's social security number, for instance, you would just reference them by a meaningless number (eg. 123456).  This number would be used in all referenced tables, as a key back to the customer table.  It is usually an integer (4 bytes worth of storage), but can be anything.


    Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
    Tuesday, October 27, 2009 7:01 PM
    Moderator
  • Thanks for reply. Is it another name of primary key? or something else. Could you please explain with example?

    Tuesday, October 27, 2009 7:07 PM
  • Thanks for reply. Is it another name of primary key? or something else. Could you please explain with example?


    http://en.wikipedia.org/wiki/Surrogate_key
    http://www.google.com/search?rlz=1C1GGLS_en-USUS299US303&sourceid=chrome&ie=UTF-8&q=surrogate+key

    It is often the dimension table's PK. 


    Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer
    • Marked as answer by sp_412000 Tuesday, October 27, 2009 7:19 PM
    Tuesday, October 27, 2009 7:13 PM
    Moderator
  •  perfect thanks
    Tuesday, October 27, 2009 7:19 PM