Data Warehousing (October – 2014) [CBSGS - 60:40 Pattern | Question Paper]

Data Warehousing (October - 2014) [CBSGS - 60:40 Pattern | Question Paper]

☛ VIEW:
@SlideShare | @Instagram | @Pinterest

☛ DOWNLOAD:
@PDF | @GitHub | @G-Drive | @TEXT | @Torrent

Time: 2 ½ Hours
Total Marks: 60

NOTE:
(1) All Question are Compulsory.
(2) Make Suitable Assumptions Wherever Necessary And State The Assumptions Made.
(3) Answer To The Same Question Must Be Written Together.
(4) Number To The Right Indicates Marks.
(5) Draw Neat Labeled Diagrams Wherever Necessary.
(6) Use of Non-Programmable Calculator is allowed.

Q.1 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is Data Warehouse? Explain.

(B) Explain Data Warehouse Architecture.

(C) Differentiate OLTP Database and Data Warehouse.

(D) Explain Star Schema Model and Snow Flake Model.

Q.2 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is the role of a listener when using the Oracle Database? Is it necessary to install the listener before the creation of the database?

(B) Why and how is repository and workspaces configured?

(C) What is defined in the Project Explorer Window, Connection Explorer Window and Global Explorer Window in the Design Center Screen?

(D) Explain the two steps involved in configuring Oracle to connect to SQL Server Database.

Q.3 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is the significance of Time Dimension in a Data Warehouse?

(B)

(i) Every editor in OWB has an area in which the contents are displayed graphically. Name and explain the same.

(ii) Name and explain the window that displays the configuration information about items in the canvas.

(C) Explain Name, Storage and Attributes tab in Dimension Details Window in the OWB Editor.

(D) Explain Name, Storage, Dimensions, Measures and Aggregations tab in Cube Details Window.

Q.4 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is the importance of staging process while creating a Data Warehouse?

(B) Explain any three source and target operators provided by Warehouse Builder.

(C) What is the role of Constraints, Attribute Sets and Data Rules tab in OWB Editor for a table?

(D) Write down the steps involved in creating a mapping.

Q.5 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) What is the role of TRIM(), UPPER(), SUBSTR Operator and TO_NUMBER () in ETL mapping?

(B) How does validation play an important role in the process of building the Data Warehouse?

(C) What are the different default operation modes of the mapping?

(D) Explain the importance of the seven columns in the object details window.

Q.6 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)

(A) Why it necessary to maintain the snapshots of an object?

(B) What is meant by synchronization of objects in mapping?

(C) Explain Standard ROLAP Architecture.

(D) Explain MOLAP Architecture.