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?
1 4323
How will you do different types of narrative reports in obiee?
How will you execute direct sql in obiee?
What is write-back in obiee ?
What are different types of joins that are possible in obiee rpd?
What is star schema and snowflake schema?
What you will do when your report is not fetching right data?
How will you go about adding additional column to the repository in the presentation layer?
What are the major challenges you faced while creating the rpd?
What are the different types of variables in obiee? Explain
How will you enable or disable caching in the system level and table level?
How we are going to decide which schema we are going to implement in the data warehouse?
How will you create report from two subject areas
What are the key configuration files in obiee?
What is scd type 1 and 2.
How online/offline mode impact development and delpoyment?