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
Sequence generator, when you move from develoment to production how will you reset
Explain the mapping variable usage example in informatica
What are the limitations of joiner transformation?
What are the restrictions of union transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
what is size of u r database?
What are junk dimensions?
What are the designer tools for creating transformations?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
lookup transformation with screenshots
What differs when we choose the sorted input for aggregator transformation?
How big was your fact table
what is the Default Source Option For Update Strategy Transformation?
explan ur project architecture?
