Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2014-05-07 : 07:52:38
|
| HI all,we are working Dwh Project using Sql server 2008.for my reporting purpose i need to Create Surrogate keys on my dimension tables.Adding identity column to the dimension tables is Surrogate keys..?HOW to create surrogate keys on Dimension tables?can anyone provide sample expmales |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-05-07 : 11:07:38
|
| Usually its something likecreate table foo(foo_id int identity(1,1) primary key)and you would normally make it the PK as well. |
 |
|
|
kond.mohan
Posting Yak Master
213 Posts |
Posted - 2014-05-09 : 08:24:41
|
| i.eWe consider as identity(system generated) column is a surrogate keymohan |
|
|
|
|
|
|
Surrogate keys creation on Dimension tables