Slowly changing dimensions

Explain the slowly changing dimensions?

E

Expert

Verified

Dimensions which change overtime are known as Slowly Changing Dimensions(SCD).

Slowly Changing Dimension-Type1: That only has current records.

Slowly Changing Dimension-Type2: That has current records + historical records.

Slowly Changing Dimension-Type3: That has current records + one previous record.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.