a) Surrogate Key is a primary key in data warehousing, the only difference between
surrogate key and primary key is that surrogate key allows duplicate values and
primary key doesn’t.

b) Surrogate key is the dummy key which is used to allow the duplicate values.

c) Surrogate key is contiguous numbers generated by DB in a table which acts as a
primary key since surrogate key has unique values.

d). It is used for duplicate values in a database. Primary keys cannot be changed
when a unique error occurs. With the help of this surrogate key a new column values will be created and that will be as primary keys.

e) Surrogate key is unique key which is used in type 2 dimension.