What is SCD1 , SCD2 , SCD3?

Submitted by: Administrator
SCD Stands for Slowly changing dimensions.

SCD1: only maintained updated values.

Ex: a customer address modified we update existing record with new address.


SCD2: maintaining historical information and current information by using

A) Effective Date

B) Versions

C) Flags

or combination of these

SCD3: by adding new columns to target table we maintain historical information and current information.
Submitted by: Administrator

Read Online General Datawarehousing Job Interview Questions And Answers