Interested to Buy Any Domain ? << Click Here >> for more details...
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
- 1 Answers
- 4414 Views
- I also Faced
- E-Mail Answers
Answer / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
| Is This Answer Correct ? | 2 Yes | 0 No |
If you want to limit the users by the certain region to access only certain data, what would you do?
What is logging level? Where can you set logging levels?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
How will you enable or disable caching in the system level and table level?
What are the challenges you faced while making of reports?
What are the different types of variables in obiee? Explain
How do you define the relationship between facts and dimensions in BMM layer?
What are the different layers of obiee repository?
How online/offline mode impact development and delpoyment?
Do you know about Initialization Blocks? Can you give me an example where you used them?
How we are going to decide which schema we are going to implement in the data warehouse?
Teradata 
