Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 30857 Views
- Informatica, Verinon Technology Solutions, I also Faced
- E-Mail Answers
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 junk dimensions?
How do you update the records with or without using update strategy?
What is the reusable transformation?
Describe data concatenation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the types of caches in lookup?
How to do the error handling of if ur source is flatfiles?
Explain why we use partitioning the session in informatica?
What are the transformations that are not supported in mapplet?
What are the data movement modes in informatica?
What are the different lookup cache(s)?
What are the different types of repositories created using informatica?
How to call shell scripts from informatica?
Why filter transformation is an active one?
how we can load rejected record's at run time?(not through bad files)
