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|
What is complex join, and where it is used?
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?
How do i disable cache for only 2 particular tables?
What is query repository tool?
Define pipeline. Did you use it in your projects?
What is the purpose of Alias Tables?
How do you define the relationship between facts and dimensions in BMM layer?
What is time series wizard? When and how do you use it?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Do you know about Initialization Blocks? Can you give me an example where you used them?
How do you work in a multi user environment? What are the steps?
How do you know which report is hitting which table, either the fact table or the aggregate table?