How will you execute direct sql in obiee?
What is star schema and snowflake schema?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What are different types of variables?
What is complex join, and where it is used?
What is clusterservices in obiee ? Why its used?
How many bi services node can be clustered together?
What are the major challenges you faced while creating the rpd?
What is object level security?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Can you use physical join in BMM layer?
What are the key configuration files in obiee?
How will change port of obiee answers?