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?






If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact?..

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

Post New Answer




More OBIEE Interview Questions

Can you have multiple data sources in OBIEE?

1 Answers  


What is data level security?

1 Answers  


What is complex join, and where it is used?

1 Answers  


What is the purpose of Alias Tables?

1 Answers  


What is Authentication? How many types of authentication do we have in OBIEE?

1 Answers  






What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?

1 Answers  


If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?

1 Answers  


You worked on standalone or integrated system?

1 Answers  


How do you implement security using External Tables and LDAP?

1 Answers  


Did you create any new logical column in BMM layer, how?

1 Answers  


Can you use outer join in BMM layer?

1 Answers  


If you want to limit the users by the certain region to access only certain data, what would you do?

1 Answers  






Categories