O'Reilly logo
  • devyani nair thinks this is interesting:

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.


Cover of Building a Scalable Data Warehouse with Data Vault 2.0


Important difference on source business key and surrogate key