BSc IT Sem 5 Data Warehousing Question Paper PDF 2026 - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt ovo of the foll b, What is source system? Briefly
   • c. Explain functional dependency of the layers in data warehouse architecture
   • d. various strategies by which ta with example organizations can get into data warehousing
2. Q2 Attempt any two of the following: : Enumerate and explain the st 10 List maj to import metadata from oracle dita source : major components of Oracle Warehouse Buil Describe the importance of OWBSYs : uilder. Also its architecture
   • d. at are data objects? Explain various functions of data editor
3. Q3 Attempt any two of the following: 10 marks
   • a. Explain about cube and dimensions with examples
   • b. are the various windows available in data object editor? Briefly explain any two of them ain the steps to create a dimension using dimeusion wizard
   • a. ine is slowly changing dimension ‘Explain type2 and type3 slowly changing ms With an example of each
4. Q4 any two of the following: a Explain staging and its advantages and. disadvantages key lookup operator with example Explain the pre/post-processing 10 marks
   • d. What are the attribute groups,present in joiner operator? Explain the steps to connect source tables to target using joiner
5. Q5 Attempt any two of the following:
   • a. Which attributes are in a cube to represent its dimensions? Also discuss the naming used fox these attributes
   • b. What is the role operator in a mapping? Describe SUBSTR transformation What are extemal tables? Explain the steps to create an external table
   • d. Write short on object validation and code generation any nwo of the following: 10
   • a. Explain data density and data sparsity in multidimensional cube with example
   • b. Briefly explain various metadata change management features in OWB
   • c. Discuss Multidimensional Online Analytical Processing
   • d. Explain the directions and matching strategies to synchronize a mapping operator with its Attempt any three of the following: 1S
   • Q) a. explain granularity and additivity of facts A b. is a Listener? Explain concisely the steps to configure a Listener
   • c. surrogate keys with an illustrative example
   • d. data flow operators. Explain the role of and filters in ETL mapping
   • e. the steps to define constant values through Constant operator Explain Real-Time Analytical Processing

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