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
What is the profile and package?
explain in detail about type 3?
How to restrict password to a user while sending a document in .pdf format
what are the day to day activities of BO administrator ?
How to execute the plsql procedure from the report by clicking with mouse?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Differences between business objects and web intelligence reports?
In banking domain how many Fact tables,Dimension table are present?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what is the difference between slice and dice and cross tab report?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
What are the join problems comes appart from loop,chasm & fan Traps
Explain 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)?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain about a tricky situation for which you found a very simple solution?
