202 ) what is use of Surrogate key is a
unique sequential auto generated andauto incremented number key column
Generated by the database operation
Normally used in a History table ( dimensions )
when the PK is duplicated to allow changes
==============================================
When to use a surrogate key
iHandling Slowly Changing Dimensions (SCD Type 2): In data warehouses, if a customer moves or changes their last name, you often want to keep historical sales tied to their old profile while creating a new record for their new profile. A surrogate key allows you to have multiple rows for the same natural business entity (e.
No comments:
Post a Comment