What do you mean by surrogate key?

1.	What do you mean by surrogate key?
Answer» Surrogate keys also referred to as artificial keys or IDENTITY keys, are system-generated identifiers used to uniquely identify each and EVERY record in the Dimension table. As a replacement for the natural primary key (changes and makes updates more DIFFICULT), the surrogate key makes updating the table easier. Also, it serves as a method for preserving historical information in SCDs (Slowly Changing Dimension).

Discussion