Interested to Buy Any Domain ? << Click Here >> for more details...
What are slowly changing dimensions?
- 5 Answers
- 30819 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
The question was on time stamp. what is the difference between HH and HH24 when to use when.
update strategy transformation in informatica
my source is junk data how will u remove that junk data by using unix please any one replay me
How to create a non-reusable instance of reusable transformations?
How do you change a non-reusable transformation to reusable transformation?
How are the sources and targets definitions imported in informatica designer?
How to Create a folder using pmrep command?
Describe an informatica powercenter?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Can we create two repositories on same database instance in oracle?
Which is the t/r that builts only single cache memory?
Do you find any difficulty while working with flat files as source and target?
Explain load alternative records / rows into multiple targets - informatica
How do you set a varible in incremental aggregation
can anyone suggest best free Talend data integration training online
