1. Can you define data warehouse?

Data warehouse is a subject oriented, integrated, time-variant, and nonvolatile collection of data that supports management's decision-making process.

2. What is the phases involved in the data warehouse delivery process?

The stages are IT strategy, Education, Business Case Analysis, technical Blueprint, Build the version, History Load, Ad hoc query, Requirement Evolution, Automation, and Extending Scope.

3. Can you list any five applications of data warehouse?

Some applications include financial services, banking services, customer goods, retail sectors, controlled manufacturing.

4. Do you know what is load manager?

A load manager performs the operations required to extract and load the process. The size and complexity of load manager varies between specific solutions from data warehouse to data warehouse.

5. Tell us how do you load the time dimension?

Time dimensions are usually loaded by a program that loops through all possible dates appearing in the data. It is not unusual for 100 years to be represented in a time dimension, with one row per day.

6. Explain me the functions of data warehouse tools and utilities?

The functions performed by Data warehouse tool and utilities are Data Extraction, Data Cleaning, Data Transformation, Data Loading and Refreshing.

7. Explain me the functions of a warehouse manager?

The warehouse manager performs consistency and referential integrity checks, creates the indexes, business views, partition views against the base data, transforms and merge the source data into the temporary store into the published data warehouse, backs up the data in the data warehouse, and archives the data that has reached the end of its captured life.

8. Do you know what does Metadata Respiratory contain?

Metadata respiratory contains definition of data warehouse, business metadata, operational metadata, data for mapping from operational environment to data warehouse, and the algorithms for summarization.

9. Explain me what is the difference between view and materialized view?

View:
☛ Tail raid data representation is provided by a view to access data from its table.
☛ It has logical structure that does not occupy space.
☛ Changes get affected in corresponding tables.
Materialized view:
☛ Pre-calculated data persists in materialized view.
☛ It has physical data space occupation.
☛ Changes will not get affected in corresponding tables.

10. Tell us what does subject-oriented data warehouse signify?

Subject oriented signifies that the data warehouse stores the information around a particular subject such as product, customer, sales, etc.

Download Interview PDF