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 |
How to get sql from obiee for reports?
How we are going to decide which schema we are going to implement in the data warehouse?
What is Authentication? How many types of authentication do we have in OBIEE?
How will you enable or disable caching in the system level and table level?
What is the difference between Data Level Security and Object Level Security?
Explain the architecture of obiee and what each components do?
What is a table alias in obiee 11g? Where and how will you create it?
What is a table alias in obiee? And where and how will you create it.
How analytics process your request when you create your requests?
How do you implement security using External Tables and LDAP?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?