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

Post New Answer




More OBIEE Interview Questions

Do you know about Initialization Blocks? Can you give me an example where you used them?

1 Answers  


What is object level security?

1 Answers  


How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?

1 Answers  


Define repository in terms of OBIEE?

1 Answers  


How do i disable cache for only 2 particular tables?

1 Answers  






What is connection pool and how many connection pools did you have in your last project?

1 Answers  


What is the purpose of Alias Tables?

1 Answers  


What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  


What is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 Answers  


 How to sort columns in rpd and web?

2 Answers  


How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?

1 Answers  


Can you migrate the presentation layer to a different server.

2 Answers  






Categories