Importance of surrogate key in data warehousing?

Ans). Surrogate key is a primary key for a dimension table. Most importance of using it is it is independent of underlying database. I.e. surrogate key is not affected by the changes going on with a database.

Leave a Reply