How Do You Manage Slowly Changing Dimensions? What Are The Fields Req

1.	How Do You Manage Slowly Changing Dimensions? What Are The Fields Required In Managing Different Types If Scd?
Answer» SCD Type 1 No HISTORY preservation Natural consequence of normalization SCD Type 2 Preserving all history and new rows There are new rows generated for significant changes You NEED to use of a unique KEY There are new fields are generated to store history data You need to MANAGE an Effective_Date field. SCD Type 3 Limited history preservation In this only two states of data are preserved - current and old

How Do You Manage Slowly Changing Dimensions? What Are The Fields Required In Managing Different Types If Scd?

Answer»