Surrogate key:
1. Surrogate Key is an artificial identifier
for an entity. In surrogate key values are generated by the system sequentially
(Like Identity property in SQL Server and Sequence in Oracle). They do not
describe anything.
2. Joins between fact and dimension tables should be based
on surrogate keys
3. Surrogate keys should not be composed of natural keys
glued together
4. Users should not obtain any information by looking at these
keys
5. These keys should be simple integers
6. Using surrogate key will be
faster
7. Can handle Slowly Changing dimensions well
