We have a requirement to implement a Type1 SCD for SQL server database. Has anyone implemented a Surrogate key generation for SQL server in Enterprise edition for SQL server 2008 in windows environment? Can anyone suggest me the best approach for implementing Surrogate Key generation for the above scenario? I am exploring the SCD stage and Key Generation stage but the database options show only DB2 and Oracle. So can we use SCD stage for sql server for Surrogate Key generation?
Thanks for your replies.
Surrogate Key generation in SQL Server
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 41
- Joined: Tue Jan 24, 2006 3:43 pm
- Location: United States
- Contact:
Surrogate Key generation in SQL Server
Knowledge is Power
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Only if your surrogate key is an integer and you're using a state file. The state file can be initialized from any source.
If you're using GUID for the keys, then you need to go back to the database using a query to generate these.
If you're using GUID for the keys, then you need to go back to the database using a query to generate these.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.