Surrogate Key in Data warehousing

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

Your email address will not be published.