Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by slowly changing dimensions?
- 3 Answers
- 8010 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 |
There are two options to set "max number of rows fetched" from designer, 1. Tools> Options 2. From universe parameters What is the different between these two and why their valus are different?
Can i use personal database connection to the Webintellegence reports?
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?
What is the report extension in webi and deski
Explain what are the measure objects?
What is batch processing in Business Objects?
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
How to Implement the the Built-in Strategy Script in BO Designer?
HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
Teradata 
