Why do we have multiple LTS in BMM layer? What is the purpose?
Answer / madhu
To improve the performance and query response time.
| Is This Answer Correct ? | 5 Yes | 0 No |
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?
How we are going to decide which schema we are going to implement in the data warehouse?
can you change the location of the obiee repository?
What is connection pool and how many connection pools did you have in your last project?
what is guided navigation?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
Define repository in terms of OBIEE?
What is Authentication? How many types of authentication do we have in OBIEE?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
What is scd type 1 and 2.
How do you implement security using External Tables and LDAP?