UGC NET CSE | December 2015 | Part 2 | Question: 34

Question

____ allows selection of the relevant information necessary for the data warehouse:

• A. The Top-Down View
• B. Data Warehouse View
• C. Datasource View
• D. Business Query View

Answer 1

ans should be A

• Four views regarding the design of a data warehouse
  • Top-down view
    • allows selection of the relevant information necessary for the data warehouse
  • Data source view
    • exposes the information being captured, stored, and managed by operational systems
  • Data warehouse view
    • consists of fact tables and dimension tables
  • Business query view
    • sees the perspectives of data in the warehouse from the view of end-user