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
- 2972 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 |
What is connection pool and how many connection pools did you have in your last project?
What is a table alias in obiee 11g? Where and how will you create it?
what is guided navigation?
How will you execute direct sql in obiee?
Can you bypass siebel analytics server security ?if so how?
What are the things you can do in the BMM layer?
What are the different types of variables in obiee 11g? Explain
How will you do sort in reports in obiee.
You worked on standalone or integrated system?
can you change the location of the obiee repository?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
Do you know about Initialization Blocks? Can you give me an example where you used them?
Teradata 
