Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by slowly changing dimensions?
- 3 Answers
- 8123 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nareshkumar
Dimensions that change over time are called Slowly Changing
Dimensions. There are three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / surya
Master data occur in the OLTP system and that can't change
regularly,When the changes are occured in the OLTP
system,that changes can be handle by the dimension
tables.Such type of dimensions is called Slowly changing
dimensions.
There are three types of dimensions
TYPE1(Maintain only current data)
TYPE2(Maintain complete historic data)
TYPE3(Maintain one historic data)
| Is This Answer Correct ? | 4 Yes | 0 No |
The data present in the dimension table changess from time to time.
For example .
Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.
So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.
www.futuresoftworld.com
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
When we use aggregate awareness function in designer?
explain about Prompt with example?
How can you access your repository with different user profiles?
WHAT IS SYNCHRONIZATION IN BOXI?
HOW TO SPOT A HIERARCHY?
What is the profile and package?
suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?
What Is The Difference Between Oltp And Olap?
HOW TO HIDE Column in WEBI & DESKI?
where are objects are stored ?
What are @FUNCTION?
what is master-detail report
Teradata 
