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
- 4527 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 is complex join, and where it is used?
What is a table alias in obiee? And where and how will you create it.
How to startup obiee in linux?
What is Authentication? How many types of authentication do we have in OBIEE?
Define pipeline. Did you use it in your projects?
Explain the architecture of obiee and what each components do?
What is write-back in obiee ?
If you want to create new logical column where will you create (in repository or dashboard) why?
What is object level security?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
How will you port changes for dashboards,reports,rpd from development to production?
What are the different layers of obiee repository?
Teradata 
