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 are the data movement modes in informatica?
What could be the possible resons of locks by user?
What is the commit type if you have a transaction control transformation in the mapping?
Which development components of informatica have the highest usage?
What is the command used to run a batch?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is a filter transformation?
How to update source definition?
What is domain in terms of informatica?
How to do unit testing in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
Repository user profiles
How to create Target definition for flat files?
How do you migrate data from one environment to another?
Please let me know how to make encryption and decryption with example?