What are slowly changing dimensions?
Answer Posted / sri ram
Slowly Changing Dimensions:(SCD)
Over period of time, the value /data associated with
dimensions may change. To track the changes we record the
changes as per the requirement.
There are three types of SCD
SCD 1:No history is maintained. As and when data comes, the
data is entered.
SCD 2: History is maintained
SCD 3: Partial History is maintained.
We maintain history for some columns but not for all.
For example,I have 3 records in a dimension
I have made 1 insert and 1 update. Then if the requirement
is that dimension is to be maintained
In SCD 1 Then
Total number of records is 4 records(1 insert & 1 update)
In SCD 2 Then
Total number of records is 5 records(1 insert & 1 update)
In SCD 3 Then
Total number of records is 4 records(1 insert & 1 update)
NOTE:
History means the slight change in the data stored and
incoming data but it doesn't means years of data.
Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
Differences between version 7.x and 8.x.
According to his methodology what all you need before you build a datawarehouse
What is aggregator transformation in informatica?
How we can use union transformation?
How does a rank transform differ from aggregator transform functions max and min?
What is the use of target designer?
Differentiate between joiner and lookup transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
How we can create indexes after completing the loan process?
What you know about transaction control transformation?
What is rank transformation?
Differentiate between source qualifier and filter transformation?
how we can load rejected record's at run time?(not through bad files)
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com