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 ?    1 Yes 0 No

Post New Answer




More OBIEE Interview Questions

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

1 Answers  


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?

1 Answers  


What are different types of variables? 

1 Answers  


How do i disable cache for only 2 particular tables?

1 Answers  


Can you have multiple data sources in OBIEE?

1 Answers  






How do you define the relationship between facts and dimensions in BMM layer?

1 Answers  


Why do we have multiple LTS in BMM layer? What is the purpose?

1 Answers  


Can you bypass siebel analytics server security ?if so how?

1 Answers  


What is connection pool and how many connection pools did you have in your last project?

1 Answers  


Can you use physical join in BMM layer?

1 Answers  


What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?

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  






Categories