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|
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
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?
What is the difference between Data Level Security and Object Level Security?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How do implement event polling table?
Why do we have multiple LTS in BMM layer? What is the purpose?
How do i disable cache for only 2 particular tables?
What are different types of variables?
Can you have multiple data sources in OBIEE?
You worked on standalone or integrated system?
How do you define the relationship between facts and dimensions in BMM layer?