What is complex join, and where it is used?
Answer / madhu
To join a dimension table and fact table in BMM layer we use a complex join.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you have multiple data sources in OBIEE?
What is a table alias in obiee 11g? Where and how will you create it?
How analytics process your request when you create your requests?
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?
What is object level security?
Can you run multiple rpd’s in a single obiee instance?
How to sort columns in rpd and web?
What are different types of joins that are possible in obiee rpd?
Can you use outer join in BMM layer?
What are the different types of variables in obiee 11g? Explain
How will you create interactive dashboards ?
How will you do sort in reports in obiee.