BSc IT Sem VI 2018 19 May 2018-19 DATAWAREHOUSING Question Paper - Mumbai University | munotes

Questions asked in this paper

1. Q1 Attempt of the following: 10 marks
   • a. What is a Data Warehouse? Explain
   • b. the architecture of a Data Warehouse
   • c. Explain the granularity of facts with a suitable example
   • d. What is meant by additivity of facts?
2. Q2 Attempt of the following: 10 marks
   • a. What are the steps to configure a listener in OWB?
   • b. How is the Repository and workspace configured using OWB?
   • c. Name and explain the three windows in the main Design Center screen
   • d. What is the role of a module in the Design Center and explain the steps to create an
3. Q3 Attempt of the following: 10 marks
   • a. star schema with a suitable example
   • c. Every dimension, has four characteristics that have to be defined in OWB. What are
   • d. What is the significance of Time Dimension and explain the steps to create a Time
4. Q4 Attempt of the following: 10 marks
   • a. What is meant by ETL in data warehouse? Explain
   • b. Explain any four source and target operators in OWB What are the four different constraints that can be added to a table?
   • d. What are the steps involved while designing any mapping in OWB?
5. Q5 Attempt any two of the following: Explain with example any four transformation operators in OWB 10 marks
   • b. What are the features and benefits of OWB?
   • c. The process of building the data warehouse from our model in the Warehouse Builder involves four steps. What are they? Explain
   • d. What are the five Default operating modes of the mapping?
6. Q6 Attempt of the following: 10 marks
   • a. What are the five operations that can be performed on Snapshots in OWB?
   • b. What is the significance of Metadata Loader (MDL) feature used for export and import of workspace objects in OWB?
   • c. happens if, let's say for example, a table definition is updated after we have defined it and created a mapping or mappings that include it? What if a dimensional object is changed? In that case, what happens to the underlying table? How is this handled in OWB?
   • d. How is the term Data Explosion related to Data warehouse?
7. Q7 Attempt any three of the following: 15 marks
   • b. OWB components with a neat diagram
   • c. Explain the various OWB design objects
   • d. Explain any four data flow operators in OWB
   • e. What are the details given by The Object Details window in control center manager?
   • f. | What is meant by Metadata change management in OWB? Explain

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