MSBI (SSIS/SSRS/SSAS) Online Training

Tuesday, June 23, 2009

SSIS - USE OF Surrogate Keys at Fact level

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: