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 is a table alias in obiee 11g? Where and how will you create it?
Have you created hierarchy in obiee. If so where and how?
What is complex join, and where it is used?
If you want to create new logical column where will you create (in repository or dashboard) why?
How to hide certain columns from a user?
How to enable drills in a given column data?
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.
If you want to limit the users by the certain region to access only certain data, what would you do?
What you will do when your report is not fetching right data?
Can you use physical join in BMM layer?
How will you create interactive dashboards ?
How to sort columns in rpd and web?