Data Warehousing (October – 2016) [CBSGS - 75:25 Pattern | Question Paper]

Data Warehousing (October – 2016) [CBSGS - 75:25 Pattern | Question Paper]

☛ VIEW:
@SlideShare | @Instagram | @Pinterest

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

Time: 2 ½ Hours
Total Marks: 75

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) Explain Star Schema Model with example.
(B) What is Source System? Briefly explain various layers in Data Warehouse Architecture.
(C) Explain Functional Dependency of the data with example.
(D) Describe various strategies by which organizations can get into Data Warehousing.

Q.2 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)
(A) Enumerate and explain the steps to import metadata from Oracle Data Source.
(B) List major components of Oracle Warehouse Builder. Also describe its Architecture.
(C) Describe the importance of OWBSYS Schema.
(D) What are Data Objects? Explain various functions of Data Editor.

Q.3 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)
(A) Explain about Cube and Dimensions with example.
(B) What are the various windows available in Data Object Editor? Briefly explain any two of them.
(C) Explain the steps to create dimension using Dimension Wizard.
(D) Define what is Slowly Changing Dimension. Explain type2 and type3 Slowly Changing Dimensions with an example of each.

Q.4 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)
(A) Explain staging and its advantages and disadvantages.
(B) Explain Key Lookup Operator with example.
(C) Explain the Pre-Post-Processing Operators.
(D) What are the attribute groups present in Joiner Operator? Explain the steps to connect source tables to target using joiner operator.

Q.5 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)
(A) Which attributes are used in a cube to represent its dimensions? Also discuss the naming conventions used for these attributes.
(B) What is the role of transformation operator in a mapping? Describe SUBSTR Transformation Function.
(C) What are External Tables? Explain the steps to create an External Table.
(D) Write short notes on Object Validation and Code Generation.

Q.6 ATTEMPT ANY TWO QUESTIONS: (10 MARKS)
(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 operators with its Repository Operator.

Q.7 ATTEMPT ANY THREE QUESTIONS: (15 MARKS)
(A) Briefly explain Granularity and Additivity of facts.
(B) What is a Listener? Explain concisely the steps to configure a Listener.
(C) Explain Surrogate Keys with an illustrative example.
(D) Define Data Flow Operators. Explain the role of aggregators and filters in ETL Mapping.
(E) Explain the step to define constant values through Constant Operator.
(F) Explain Real-Time Analytical Processing.