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 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 we are going to decide which schema we are going to implement in the data warehouse?
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?
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?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is clusterservices in obiee ? Why its used?
What is complex join, and where it is used?
What is data level security?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
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 are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?