Surrogate key generator
Posted: Wed Mar 24, 2010 1:42 am
Hi
my source data is like for example
KeyColNm Surrogatekey
------------
A .............10
A .............20
A .............30
A .............40
B .............10
B .............20
B .............30
C .............10
C .............20
C .............30
C .............40
C ............. 50
Means, like my requirement is when data value changes in key column, then the surrogate value should start from initial values and should increment 10 when the value is repeating.
Any suggestions please
Thanks
my source data is like for example
KeyColNm Surrogatekey
------------
A .............10
A .............20
A .............30
A .............40
B .............10
B .............20
B .............30
C .............10
C .............20
C .............30
C .............40
C ............. 50
Means, like my requirement is when data value changes in key column, then the surrogate value should start from initial values and should increment 10 when the value is repeating.
Any suggestions please
Thanks