Surrogate keys are often used by operational systems to identify the business object. However, they are not good candidates for a business key if the business itself is not using them. As soon as the business uses the surrogate key to uniquely identify (and track) data in the source system, the surrogate key becomes a business key.
- Chapter 4: Data Vault 2.0 Modeling
- from Building a Scalable Data Warehouse with Data Vault 2.0
- Publisher: Morgan Kaufmann
- Released: September 2015
Important difference on source business key and surrogate key