Importance of surrogate key in Data warehousing

What is the importance of surrogate key in Data warehousing?



-Surrogate key will come into picture when dimension in a table is changing slowly

-Surrogate key can identify the changes made in various dimensions

-The three slowly changing dimensions are (1) SCD1, (2) SCD2 and (3) SCD3.

-Surrogate keys are generated by the system.

-The keys are the sequence numbers / alphanumeric values
Post your comment