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
- 4523 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 |
Have you created hierarchy in obiee. If so where and how?
What is connection pool and how many connection pools did you have in your last project?
What is a table alias in obiee? And where and how will you create it.
What is Authentication? How many types of authentication do we have in OBIEE?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
What are the things you can do in the BMM layer?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
Can you use outer join in BMM layer?
What are the different types of variables in obiee 11g? Explain
What is logging level? Where can you set logging levels?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Teradata 
