Surrogate key is an artificial or synthetic key that is used as a substItute for a natural keys.It is just a unique identifier or number for each row that can be used for the primary key to the table.(It is a sequence generate key which is assigned to be a primary key in the system(table)).
See the below link.GoodOne.
http://blogs.msdn.com/sqlcat/archive/2009/05/13/assigning-surrogate-keys-to-early-arriving-facts-using-integration-services.aspx
No comments:
Post a Comment