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

Data Warehousing (April – 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) State and justify the characteristics of a Data Warehouse with suitable example.

(B) Differentiate OLTP and OLAP.

(C) Discuss the different types of facts with respect to measures stored in the fact table in a Data Warehouse.

(D) Why a dimension is called slowly changing dimension? Explain.

Q.2. Attempt Any Two Questions: (10 Marks)

(A) What is a relationship between OWBSYS and Oracle Warehouse Builder?

(B) Solve following:

    (i) Name and define the utility that has to be configured before creating an Oracle Database.

      (ii) Draw a neat diagram that illustrates the various component of OWB.

(C) What is the significance of HS Parameters in the Heterogeneous Service Configuration File?

(D) Explain the term module with reference to the design of a DW in Design Center.

Q.3. Attempt Any Two Questions: (10 Marks)

(A) Explain the Relational Implementation of a Dimensional Model – Star Schema.

(B) Name and explain the object that are Relational and Dimensional Objects in Oracle Module.

(C) Every Dimension has four characteristics that have to be defined in OWB. What are they?

(D) Explain the tabs Name, Storage, Attributes, Levels and hierarchies in Editor. The Window of any object that is currently being edited.

Q.4. Attempt Any Two Questions: (10 Marks)

(A) What is ETL? Explain with an example.

(B) Explain the data flow operators:

      (i) Aggregator

      (ii) Joiner

      (iii) Expression

(C) What is set in the Keys tab in the Table Editor Window in OWB?

(D) Explain the Indexes and Partitions tab in the Table Editor.

Q.5. Attempt Any Two Questions: (10 Marks)

(A) Discuss any three transformation operators used in ETL processing.

(B) What is the role of a LOOKUP operator in a Mapping?

(C) Explain Full and Intermediate Generation Styles.

(D) Solve the following:

      (i) Validation will result in one of the three possibilities. What are they?

      (ii) Mention the five default operating mode of the mapping.

Q.6. Attempt Any Two Questions: (10 Marks)

(A) What are the different operations that can be performed on a snapshot of an object that is created?

(B) What happens if, let’s say, for example, a table definition is updated after we have defined it and created a Mapping or Mappings that included it?

(C) What is the difference between ROLAP and MOLAP?

(D) Illustrate Data Explosion with reference to Data Storage in Data Warehouse.

Q.7. Attempt Any Three Questions: (15 Marks)

(A) Explain Snow Flake Schema with an example.

(B) The first step required in making use of Oracle Heterogeneous Services used to access a Non-Oracle Database is to create an ODBC Connection. How is this Connection established?

(C) Define and explain term Staging with respect to ETL Processing.

(D) Differentiate Surrogate Identifier and Business Identifier with suitable examples.

(E) The process of building the DW from the model created in the Warehouse Builder involves Deploying and executing. Discuss.

(F) Explain the Change Management related Toll - The Metadata Loader.