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 |
What are the challenges you faced while making of reports?
From where u get the logical query of your request?
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.
What is query repository tool?
What you will do when your report is not fetching right data?
How to hide certain columns from a user?
How will change port of obiee answers?
What are different types of joins that are possible in obiee rpd?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How do i disable cache for only 2 particular tables?
What is authentication? How many types of authentication.
If you want to create new logical column where will you create (in repository or dashboard) why?