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 |
What are the challenges you faced while making of reports?
What are different types of variables?
What is a table alias in obiee? And where and how will you create it.
How will change port of obiee answers?
How many bi services node can be clustered together?
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 the end to end life cycle of OBIEE?
Can you migrate the presentation layer to a different server.
Did you create any new logical column in BMM layer, how?
What is a bridge table ?
Define pipeline. Did you use it in your projects?
If you want to limit the users by the certain region to access only certain data, what would you do?