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
- 4288 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 |
How to startup obiee in linux?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Can you bypass siebel analytics server security ?if so how?
What are the different types of variables in obiee 11g? Explain
What is connection pool and how many connection pools did you have in your last project?
How will change port of obiee answers?
Do you know about Initialization Blocks? Can you give me an example where you used them?
How to hide certain columns from a user?
How do you implement security using External Tables and LDAP?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
What is logging level? Where can you set logging levels?
How to get sql from obiee for reports?
Teradata 
