Answer Posted / mahesh225
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 |
Post New Answer View All Answers
Give some information on report bursting?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
When to use local filter and when to use global filter?
what will be the contents for a functional requirements specifications
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
what are the tables used in health care domain project and columns used in report?
Explain the difference between union and group?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what would you consider as your biggest achievement and why?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Is there any other repository domains rather than universe, security, document?
When we use aggregate awareness function in designer?
Explain is there any other repository domains rather than universe, security, document?