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

is surrogate key same primary key in oltp system?

surrogate key substitution natural primary key. unique identifier or number each row can used primary key table. requirement surrogate primary key is unique each row in table. data warehouses typically use surrogate (also known artificial or identity key) key dimension tables primary keys. can use infa sequence generator, or oracle sequence, or sql server identity values surrogate key. useful because natural primary key (i.e. customer number in customer table) can change , makes updates more difficult.

for more information @ forum.