General Datawarehousing Question:
What is SCD1 , SCD2 , SCD3?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain me what is VLDB? | Explain What is What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables? |