1
1. What is Data warehouse?
Explanation: A data warehouse (DW or DWH) is a database used for reporting and analysis. The data stored in the warehouse are uploaded from the operational systems (such as marketing, sales etc., shown in the figure to the right). The data may pass through an operational data store for additional operations before they are used in the DW for reporting.

Directing to forums.. wait...!

2. what are the types of data warehouses?
Explanation: There are three types of data warehouses. Enterprise Data Warehouse,ODS (operational data store), and Data Mart

Directing to forums.. wait...!

3. What is Data mart?
Explanation: A data mart is a subset of data warehouse that is designed for a particular line of business, such a

Directing to forums.. wait...!

4. What is star schema?
Explanation: A star schema is the simplest form of data warehouse schema that consists of one or more dimensional

Directing to forums.. wait...!

5. What is snow flake schema?
Explanation: A Snowflake schema is nothing but one Fact table which is connected to a number of dimension tables,

Directing to forums.. wait...!

6. What are ETL Tools?
Explanation: ETL Tools are stands for Extraction, Transformation, and Loading the data into the data warehouse fo

Directing to forums.. wait...!

7. What are Dimensional table?
Explanation: Dimension tables contain attributes that describe fact records in the fact table.

Directing to forums.. wait...!

8. What is data Modelling?
Explanation: Data Modeling is representing the real world set of data structures or entities and their relationsh

Directing to forums.. wait...!

9. What is Surrogate key?
Explanation: Surrogate key is a substitution for the natural primary key. It is just a unique identifier or numbe

Directing to forums.. wait...!

10. What is Data Mining?
Explanation: A Data Mining is the process of analyzing data from different perpectives and summarizing it into us

Directing to forums.. wait...!