what is meant by slowly changing dimensions?
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 |
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
What is object stores?
How to hide the table s in webi?can any one tell me plzzzzzzzz
How can you check the universe?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Iam having an report it contain n number of rows i want to desplay each rows in one colur pls explain me its very important
What is a Set?
What is security level in BO ?
How many tables can an universe contain is their any limit to insert tables in the universe?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
How to create a report template BO XI R2