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
- 4431 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 |
What are the different types of variables in obiee? Explain
How do implement event polling table?
If you want to limit the users by the certain region to access only certain data, what would you do?
Did you create any new logical column in BMM layer, how?
How to hide certain columns from a user?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
How will change port of obiee answers?
How analytics process your request when you create your requests?
What is a table alias in obiee 11g? Where and how will you create it?
Define repository in terms of OBIEE?
How will you create interactive dashboards ?
How do you work in a multi user environment? What are the steps?
Teradata 
