Surrogate key implemetation

[dr.murthy]

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...

[Sreenivasulu]

Use Lookup stage if the records are less . Use database sequencer is records are more. There is much more to it.
This is a design question and does not have a straght 'yes/no' answer.
It depends on the business requirement.

Regards
Sreeni

[chulett]

It also depends on concurrency needs - will the target table be loaded by more than one process simulateously?