Answer Posted / 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 |
Post New Answer View All Answers
What is aggregate table and aggregate fact table ... Any examples of both?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
What is the difference between datawarehousing and businessintelligence?
what are the tables used in health care domain project and columns used in report?
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 difference between absolute and relative div positioning?
Explain how to schedule the report in b.o?
Explain what would you consider as your biggest achievement and why?
8. How much supervision have you typically received in your previous job?
What is the difference between slice and dice and cross tab report?
how to create reports on screech?
What are the steps to do to use alerts in bo?
Explain about a time when you discovered a more efficient way to do a work task?
How to create Index to the table in the universe designer and how it improves the Query performence
Can more than 1 metric be applied on an analytic in business objects?