Answer the following 1. ETL stands for__________. 2. Define metadata. 3. What is Exploration Warehouse? 4. Define term: de-normalization 5. Explain concept hierarchy 6. Define the structure data. 7. ODS stands for___________.
[7 marks]Draw and explain the data warehouse architecture
[7 marks]Differences between operational database systems and data warehouses.
[7 marks]Define data warehouse and explain the different data models.
[7 marks]Why we need to build data mart? List the advantages and disadvantages of data mart
[7 marks]What is the difference between ER Modeling and Dimensional Modeling?
[7 marks]What is a snapshot? Explain various triggers of a snapshot in brief.
[7 marks]What is meta data? How to manage reference tables in a data warehouse?
[7 marks]Explain in brief the feedback loop techniques for deciding the levels of granularity in a data warehouse.
[7 marks]Explain the relation between EIS and data warehouse in detail.
[7 marks]What do you mean by contextual information? Explain its types and state their importance in the context of data warehousing environment.
[7 marks]Explain the different OLAP operation with suitable examples.
[7 marks]Explain the process of relating the structured and unstructured environments of data warehouse.
[7 marks]What are the parameters to be consider while moving data from the web to the data warehouse?
[7 marks]Explain Data Driven Development Methodology.
[7 marks]How is unstructured data organized in a data warehouse? Explain the process of managing the volume of data in an unstructured data warehouse.
[7 marks]What do you mean by independent data mart? State its advantages and disadvantages.
[7 marks]