What is connection pool and how many connection pools did you have in your last project?
Answer / madhu
Connection pool is needed for every physical database.
It contains information about the connection to the database, not the database itself.
Can use either shared user accounts or can use pass-through accounts
We can have multiple connection pools for each group to avoid waiting
| Is This Answer Correct ? | 1 Yes | 0 No |
How do implement event polling table?
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?
If you want to limit the users by the certain region to access only certain data, what would you do?
What is a table alias in obiee 11g? Where and how will you create it?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How will you go about adding additional column to the repository in the presentation layer?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
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?
What is connection pool and how many connection pools did you have in your last project?
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 are the things you can do in the BMM layer?