In a current database, the surrogate key is the primary key,
generated by the database management system and not derived
from any application data in the database. The only
significance of the surrogate key is to act as the primary key.

Dr.Karthik.k

Surrogate Key is unique identifier Key in Production 
System, to avoid data duplication and redundancy in DWH

A surrogate key is a substitution for the natural primary 
key. It is just a unique identifier for each row that can 
be used for the primary key to the table.

surrogate key is a system generated key which is defined at
database level to avoid the duplication of records it dosent
mantain any relations btwn tables like as primary key and it
only allows unique data there is a command with sequence in
oracle..just check it out

an artificial key which can be used to remove redundancy

A surrogate key is an automatic system generated unique key.

Surrogate key: Also known as Sequence id in ORACLE or 
Identity column in SQL SERVER (whatever you call to your 
convenience).Auto generated keys by the system.

DWH: Used here as a substitute of existing primary key to 
encourage duplicates and thereby misleading the rule of 
third normal form. Thus maintaining the history of records 
which supports SCD(slowly Changing Dimension III)

3NF: Each table should have one primary key