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
- 1183 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 ? | 2 Yes | 0 No |
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
How do implement event polling table?
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?
Define repository in terms of OBIEE?
How to sort columns in rpd and web?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is data level security?
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?
How do i disable cache for only 2 particular tables?
What is level based metrics?
You worked on standalone or integrated system?
Teradata 
