Can you use outer join in BMM layer?






Answer / madhu

Yes we can. When we are doing complex join in BMM layer in the join properties we have an option to change the type of join to left outer, right outer, full outer or inner.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer




More OBIEE Interview Questions

Define pipeline. Did you use it in your projects?

1 Answers  


Can you use physical join in BMM layer?

1 Answers  


How do you implement security using External Tables and LDAP?

1 Answers  


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  


What is logging level? Where can you set logging levels?

1 Answers  






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

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 is the difference between Single Logical Table Source and Multiple Logical Table Sources?

1 Answers  


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

1 Answers  


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

1 Answers  


What is the difference between Data Level Security and Object Level Security?

1 Answers  


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

1 Answers  






Categories