Interested to Buy Any Domain ? << Click Here >> for more details...
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 Answers
- 4518 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is star schema and snowflake schema?
How will you execute direct sql in obiee?
What is a table alias in obiee 11g? Where and how will you create it?
How will you port changes for dashboards,reports,rpd from development to production?
How to startup obiee in linux?
What are the challenges you faced while making of reports?
Have you created hierarchy in obiee. If so where and how?
From where u get the logical query of your request?
What is write-back in obiee ?
What are the key configuration files in obiee?
How we are going to decide which schema we are going to implement in the data warehouse?
What are the different log files in obiee?
How will you do sort in reports in obiee.
How to get sql from obiee for reports?
What is authentication? How many types of authentication.
