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 do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is clusterservices in obiee ? Why its used?
What is the end to end life cycle of OBIEE?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
Can you use physical join in BMM layer?
What are the key configuration files in obiee?
What is connection pool and how many connection pools did you have in your last project?
What are the things you can do in the BMM layer?
What is a table alias in obiee? And where and how will you create it.
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
How online/offline mode impact development and delpoyment?
How do you define the relationship between facts and dimensions in BMM layer?