Data Warehousing
1. With necessary diagram, Describe about Data Warehouse Development Life Cycle.
2. Elucidate Metadata and what is its use in Data Warehouse Architecture?
3. Explain in brief about any four ETL tools. What is transformation?
Briefly explain the fundamental transformation types.
4. What are ROLAP, MOLAP and HOLAP? Explain about Multidimensional Analysis? How do we achieve it?
5. Elaborate testing process for Data Warehouse with necessary diagram.
6. What do you understand by testing?
Differentiate between Data Warehouse testing and traditional software testing.