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|
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
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.
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is the difference between Data Level Security and Object Level Security?
What is level based metrics?
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 different types of variables?
What is Authentication? How many types of authentication do we have in OBIEE?
How do you implement security using External Tables and LDAP?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
Did you create any new logical column in BMM layer, how?
Why do we have multiple LTS in BMM layer? What is the purpose?