BSc IT Sem VI ATKT 2016-17 ATKT Data Warehousing Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q2 Attempt any two of the following:
   • a.- Enumerate and explain the steps 10 List to metadata from oracle dita sourc mponcats of Oracle Warehouse Build e the importance of schema
2. Q4 at are data obj objects? Explain various functions of data editor
3. Q3 any of the following: ows available in data object editor? lai e what is slowly changi i dimensions with an typed, and. changing 4, Attempt any two of the following:
   • a. Explain staging and its advantages
   • b. Explain key lookup operator with example
   • c. Explain the pre/post-processing operators
   • d. are in joiner operator? Explain the steps to connect source
4. Q5 Attempt any of the {cilowing: 10 marks
   • a. Which attributes in a cube to represent its dimensions? Also discuss the naming
   • b. What is the role operator in a mapping? Describe SUBSTR transformation
   • c. What are external tables? Explain the steps to create an external table
   • d. Write short notes on object validation and code generation
5. Q6 any two of the following: 10 marks
   • a. Explain data density and data sparsity in multidimensional cube with example
   • b. Briefly explain various metadata change management features in OWB
   • d. the directions and matching strategies to synchronize a mapping operator with its any three of the following: 15 Briefly explain granularity and additivity of facts q What is a Listener? Explain concisely the steps to configure a Listener Explain surrogate keys with an illustrative example
   • d. Define data flow operators. Explain the role of and filters in ETL mapping
   • e. Explain the steps to define constant values through Constant operator a Explain Real-Time Analytical Processing

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