| September 09, 2008 02:02:07 |
#7 |
| lakshmib |
Member Since: September 2008 Total Comments: 3 |
RE: What is the role of surrogate keys in data warehouse and how will u generate them?
|
| 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. Primary Key is a natural identifier for an entity. In Primary keys all the values are entered manually by the user which are uniquely identified. There will be no repetition of data. |
| |
