BSc IT Sem VI ATKT Dec 2019 ATKT DATAWAREHOUSING Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt any two of the following: 10 marks
   • a. Differentiate between operational DBMS and a data warehouse
   • b. Explain about fact table and dimension tables in a star schema
   • c. Define granularity of facts. Discuss about high and low granularity of facts in a
   • d. Explain multi valued dimensions with example
2. Q2 Attempt any two of the following: 10 marks
   • a. What is a source module? How is it created?
   • b. are Oracle Warehouse Builder’s client side and server side components? Briefly explain the role of design center
   • c. oracle database versions support warehouse builder? Discuss hardware and operating system requirements for installing OWB
   • d. What is source system metadata? Explain various steps to import metadata from flat files using import metadata wizard in OWB
3. Q3 Attempt of the following: 10 marks
   • a. explain about cube and dimension in dimensional model
   • b. various characteristics of a dimension
   • c. Explain surrogate keys and business keys with examples
   • d. Write short notes on:
4. Q4 Attempt any two of the following: 10 marks
   • a. What is deduplicator operator? How is it used in a mapping?
   • b. What is staging in ETL process? What are its benefits?
   • c. What is ETL? Explain about filter operator used in ETL mapping
   • d. What are the attribute groups of joiner operator? Explain steps to connect source tables to target table using joiner
5. Q5 Attempt any two of the following: 10 marks
   • a. What is expression operator? Explain the mapping of expression operator What is transformation operator? How is UPPER() transformation function used?
   • c. What is object deployment? What are the various deploy actions in object details What are the various steps to create constants through Constant operator?
6. Q6 Attempt of the following: 10 marks
   • a. What is multidimensional OLAP? What are its advantages and drawbacks?
   • b. short notes on the following features of OWB
   • ii. Cut, copy, and paste
   • c. Explain data explosion in multidimensional models
   • d. What is a Snapshot? How do you compare one Snapshot with another in OWB?
7. Q7 Attempt any three of the following: 15 marks
   • a. | What is a source system? Explain various layers in data warehouse architecture
   • b. Write short notes on and TRIM transformation functions
   • c. Why is it necessary to synchronize table operators in a mapping with corresponding repository objects? Explain Match by Object Identifier and Match By Object Name synchronization strategies
   • d. Explain about explorer, palette and property inspector windows in mapping editor
   • e. Explain about key lookup and external table operators in brief
   • f. | What is the significance of listener process in oracle database server? How is it

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