Hi all,
i just plan to implement a surrogate key in my SCD jobs, i have three approches like
1)Database sequencer
2)Using lookup Stage by getting the max Suurogate key for a particular table
3)Call a parallel routine.
Can any clarify me which approach is Better to implement ,Datbase we used is Sqlserver2005.
Thanks alll...
Surrogate key implemetation
Moderators: chulett, rschirm, roy
Surrogate key implemetation
D.N .MURTHY
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am