Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Surrogate key or Natural key
Correction -- ... isolated to the "dimension" table?- dburke44
- Post #17
- Forum: Data Warehousing/Big Data
-
Surrogate key or Natural key
I fully understand the benefits of the surrogate key, including slowly changing dimensions, its just that this situation regarding users searching very often on a natural key never seems to get addressed in discussion or articles that advocate surrogate keys. In fact, my inclination would be to...- dburke44
- Post #16
- Forum: Data Warehousing/Big Data
-
Surrogate key or Natural key
I'd like to get back to one of the first points in the first thread. If, for instance, there is a natural key called ProductCode in the production OLTP source system, and this code is 4 bytes in length, and the users will commonly be searching against this code in their "where" clauses, then...- dburke44
- Post #14
- Forum: Data Warehousing/Big Data
