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|
Define pipeline. Did you use it in your projects?
Can you use physical join in BMM layer?
How do you implement security using External Tables and LDAP?
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?
What is logging level? Where can you set logging levels?
Can you bypass siebel analytics server security ?if so how?
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?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
What is connection pool and how many connection pools did you have in your last project?
Why do we have multiple LTS in BMM layer? What is the purpose?
What is the difference between Data Level Security and Object Level Security?
How do you define the relationship between facts and dimensions in BMM layer?