| September 09, 2005 05:56:03 |
#1 |
| abhishek |
Member Since: Visitor Total Comments: N/A |
RE: Importance of Surrogate Key in Data warehousing?
|
The concept of surrogate comes into play when there is slowely changing dimension in a table.
In such condition there is a need of a key by which we can identify the changes made in the dimensions.
These slowely changing dimensions can be of three type namely SCD1,SCD2,SCD3.
These are sustem genereated key.Mainly they are just the sequence of numbers or can be alfanumeric values also.
|
| |
