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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-07-15 : 10:30:29
|
| Manish writes "Hello,I am working on Datawarehouse table structure. I have license Dimension and License fact Tables. I thought of having only one primary key as License ID in License Dimension table but when I saw sample data we do have same license ID repeating with management reporting key. Now in License Dimension I would like to have only one key as a primary key so how should I create the surrogate key. I mean I did not see anywhere any SQL statement to create surrogate key. How we do that?" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-07-15 : 17:19:49
|
| You need to put an identity column on the dimension table, and let it serve as your surrogate key.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
|
|
|
Creating Surrogate Key