Answer / madhu
OBIEE life cycle:
1. Gather Business Requirements
2. Identify source systems
3. Design ETL to load data to the Data Warehouse
4. Build a repository
5. Build dashboards and reports
6. Define security (LDAP or External table)
7. Based on performance, decide on aggregations and/or caching mechanism.
8. Testing and QA.
|Is This Answer Correct ?||6 Yes||0 No|
Can you use physical join in BMM layer?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Can you use outer join in BMM layer?
What is connection pool and how many connection pools did you have in your last project?
How do you implement security using External Tables and LDAP?
If you want to create new logical column where will you create (in repository or dashboard) why?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
What is level based metrics?
How do i disable cache for only 2 particular tables?
How do you define the relationship between facts and dimensions in BMM layer?
Can you have multiple data sources in OBIEE?
What is the purpose of Alias Tables?