What is the difference between a Technical key and a Surrogate key?

1.5k views Asked by At

Is a surrogate key the same as a primary key in an OLTP system?

1

There are 1 answers

2
israel altar On

Surrogate key is a substitution for the natural primary key. It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table. Data warehouses typically use a surrogate (also known as artificial or identity key) key for the dimension tables primary keys. They can use Infa sequence generator, or Oracle sequence, or SQL Server Identity values for the surrogate key. It is useful because the natural primary key (i.e. Customer Number in Customer table) can change and this makes updates more difficult.

for more information look at this forum.