BSc IT Sem VI 2016 17 2016-17 Datawarhousing Question Paper - Mumbai University | munotes

Questions asked in this paper

• Please check whether you have got the right question paper

1. Q1 Attempt any two of the following: 10 marks
   • a. are operational databases? Explain following characteristics of data in a data
   • i) Subject-oriented
   • ii) Integrated
   • b. virtual data warehouse and its advantages
   • c. Explain star schema model in relational implementation of data warehouses
   • d. What is data aggregation? Explain granularity of facts
2. Q2 Attempt any two of the following: 10 marks
   • a. Explain about data objects and data object editor of Oracle Warehouse Builder
   • b. various components of OWB. Explain major functions of design center
   • c. is meant by importing metadata? Explain steps to import metadata from flat
   • d. Whatisa listener? How is it configured?
3. Q3 Attempt any two of the following: 10 marks
   • a. about dimensional modeling of data warehouse What is the use of canvas area in data object editor? Also explain the explorer and
   • c. Explain various steps to create.a dimension using dimension wizard
   • d. What are surrogate keys? Explain the need of surrogate keys with example
4. Q4 Attempt any two of the following: 10 marks
   • a. What is joiner operator? Explain steps to use it in a mapping
   • b. What is the role of cube operator in mapping? Discuss various attributes in cube
   • Q. P. Code: 08221
   • c. Describe aggregator and filter data flow operators
   • d. Write short notes on the following:
   • i) Extract, Transform and Load
   • ii) Source to target map
5. Q5 Attempt any two of the following: 10 marks
   • a. What is expression operator? Explain TO_CHAR() functions with proper syntax and
   • b. Write a detailed note on data object validation in OWB What is constant operator? Explain steps to create constants in mapping
   • d. various functions of control center manager
6. Q6 Attempt any two of the following: 10 marks
   • a. Explain clipboard and recycle bin features of oracle warehouse builder
   • b. is Metadata Loader? What are its benefits?
   • c. Explain data density and data sparsity with example
   • d. Explain ROLAP and its merits
7. Q7 Attempt any three of the following: 15 marks
   • b. is Oracle Warehouse Builder? Explain the significance of projects and modules
   • c. | Whytime dimension is important in data warehouse? Explain various steps to create it through time dimension wizard
   • d. Write note on staging and its benefits
   • e. Describe SUBSTR transformation function
   • f. What are snapshots? Explain full snapshot and signature snapshot

Read from the scan above, so a character or two may differ. The scan is the original.