Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 2878 Views
- I also Faced
- E-Mail Answers
Answer / madhu
Find the SQL query of the report in Admin->manage Session-> view log then run the SQL query on toad if it takes the same time even in TOAD then modify the query to reduce the query time. If the query runs normally in TOAD then we need to make changes in the repository.
| Is This Answer Correct ? | 4 Yes | 0 No |
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 a table alias in obiee 11g? Where and how will you create it?
what is guided navigation?
What is complex join, and where it is used?
How do you work in a multi user environment? What are the steps?
What is the purpose of Alias Tables?
How will change port of obiee answers?
How will you go about adding additional column to the repository in the presentation layer?
Can you use physical join in BMM layer?
How do you know which report is hitting which table, either the fact table or the aggregate table?
What are the challenges you faced while making of reports?
Define repository in terms of OBIEE?
Teradata 
