1. What is Summary Information?

Summary Information is the area in data warehouse where the predefined aggregations are kept.

2. Define dimension?

The dimensions are the entities with respect to which an enterprise keeps the records.

3. Define metadata?

Metadata is simply defined as data about data. In other words, we can say that metadata is the summarized data that leads us to the detailed data.

4. Explain data mart?

Data mart contains the subset of organization-wide data. This subset of data is valuable to specific groups of an organization. In other words, we can say that a data mart contains data specific to a particular group.

5. List the Schema that a data warehouse system can implements?

A data Warehouse can implement star schema, snowflake schema, and fact constellation schema.

6. How many fact tables are there in a star schema?

There is only one fact table in a star Schema.

7. What is Virtual Warehouse?

The view over an operational data warehouse is known as virtual warehouse.

8. List any five applications of data warehouse?

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

9. 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 stigmatization.

10. Explain what is Normalization?

Normalization splits up the data into additional tables.

Download Interview PDF