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
- 2963 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 will you do sort in reports in obiee.
What are the key configuration files in obiee?
How we are going to decide which schema we are going to implement in the data warehouse?
Define pipeline. Did you use it in your projects?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
what is guided navigation?
What is scd type 1 and 2.
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What are the challenges you faced while making of reports?
What is the difference between Data Level Security and Object Level Security?
If you want to limit the users by the certain region to access only certain data, what would you do?
What is connection pool and how many connection pools did you have in your last project?
Teradata 
