Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pradeep
scd-slowly changing dimension
It is the capturing the slowly changing data which changes
very slowly with respect to the time. for example: the
address of a custumer may change in rare case. the address
of a custumer never changes frequently.
there are 3 types of scd. type1 - here the most recent
changed data is stored
type2- here the recent data as well as all past data
(historical data) is stored
trpe3- here partially historical data and recent data are
stored. it mean it stores most recent update and most recent
history.
As datawarehouse is a historical data, so type2 is more
usefull for it.
(welcome new answers)
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
What is a mapplet/worklet in informatica?
What are the static cache and dynamic cache in informatica?
Why update strategy and union transformations are active? Explain with examples.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Which is the t/r that builts only single cache memory?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Enlist few areas or real-time situations where informatica is required.
What are mapplets?
How might you approve all mappings in the archive all the while?
Why is sorter an active transformation?
Which transformation is needed while using the Cobol sources as source definitions?
Mention few power centre client applications with their basic purpose?
can we override a native sql query within informatica? Where do we do it?
Clarify the aggregator change?
What are the new features of Power Center 5.0?
