Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by slowly changing dimensions?
- 3 Answers
- 8222 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 |
12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?
1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?
What is security domain in Business Objects?
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
Is it possible to develop reports without Universe access?
What is batch processing in Business Objects?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
what do u mean by variable functions ?
Can we Save (save as) WEBI Doc as DESKI?
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
rows are hide in deski,what is process,i know hide the colomn it is fulldown menu,formate>table formate>pivote>hide button,but not rows plz any body give the answer?
Teradata 
