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 4419
How we are going to decide which schema we are going to implement in the data warehouse?
What you will do when your report is not fetching right data?
What is scd type 1 and 2.
Explain the architecture of obiee and what each components do?
How will you go about adding additional column to the repository in the presentation layer?
What are the different types of variables in obiee 11g? Explain
How will you do sort in reports in obiee.
How will you port changes for dashboards,reports,rpd from development to production?
How to enable drills in a given column data?
What is write-back in obiee ?
can you change the location of the obiee repository?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you create interactive dashboards ?
How the users created differs from rpd/answers/dashboards level?
What is a bridge table ?