A surrogate key is a substitution for the natural primary key. It is a unique identifier or number ( normally created by a database sequence generator ) for each record of a dimension table that can be used for the primary key to the table.
A surrogate key is useful because natural keys may change.
No comments:
Post a Comment