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
- 4427 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the different layers of obiee repository?
What are the challenges you faced while making of reports?
Define repository in terms of OBIEE?
How do i disable cache for only 2 particular tables?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
How to startup obiee in linux?
Define pipeline. Did you use it in your projects?
Why do we have multiple LTS in BMM layer? What is the purpose?
Can you bypass siebel analytics server security ?if so how?
How do you implement security using External Tables and LDAP?
What is star schema and snowflake schema?
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?
Teradata 
