| October 10, 2005 07:02:58 |
#3 |
| Venkat |
CRM Expert Member Since: October 2005 Total Comments: 2 |
RE: What is surrogate key ? where we use it expalin wi...
|
| Dear User,When creating a dimension table in a data warehouse, we generally create the tables witha system generated key to unqiuely identify a row in the dimension. This key is also known as a surrogate key. The surrogate key is used as the primary key in the dimension table. The surrogate key will also be placed in the fact table and a foreign key will be defined between the two tables. When you ultimately join the data it will join just as any other join within the database. should you need any further assistance pls revert to this mail id venkatdba2000@yahoo.com or venkata.veluri@gmail.comRegardsVen (Venkat) |
| |
