In addition to giving each record of a dimension a new value that serves as a primary key within the dimensional model instead of the operational key value,surrogate key values contain additional information about each record in the dimension.

Question

Quizplus · Accepted Answer

Surrogate keys are used in dimensional modeling to uniquely identify each record in a dimension table, but they do not contain additional information about the records themselves; their primary purpose is to serve as a unique identifier.

In Addition to Giving Each Record of a Dimension a New