Data Warehouse (DWH) Basics

Data Warehouse Basics

1. What is Data?

A. Data is a collection of information which gives sense or meaning. i.e., Any meaningful information is called      called Data.

2. What are the different types of Data?

A. Data is 2 types. They are

        1. Transactional Data

        2. Analytical Data

3. What is Transactional Data?

A. Transactional data is run time data or day to day data. It is current and detail in nature. Transactional data       is stored in On Line Transaction Processing (OLTP). This is useful to run the business. Applications such       as Share Market Transactions, ATM Transactions are sources of Transactional Data. 

4. What is Analytical Data?

A. Analytical Data is data which is used for analyzing the business. It is historical and summarized data. It is        sourced in On Line Analytical Processing(OLAP), or Data Warehouse(DW).

5. What is Data Warehouse?

A. A data warehouse is a relational database that is designed for query and analysis rather than for                      transaction processing. It usually contains historical data derived from transaction data, but it can include        data from other sources. It separates analysis workload from transaction workload and enables an                organization to consolidate data from several sources.

6. Draw Data Warehouse Architectue.

A. In addition to a relational database, a data warehouse environment includes an extraction, transportation,        transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis      tools, and other applications that manage the process of gathering data and delivering it to business users.

    

    In addition to a relational database, a data warehouse environment includes an extraction, transportation,       transformation, and loading (ETL) solution, an online analytical processing (OLAP) engine, client analysis       tools, and other applications that manage the process of gathering data and delivering it to business users.

                                                   Data Warehouse Architecture

7. What are different types of Data Warehouse Tools?

A. Data Warehouse tools are divided into 2 types

  

         1. ETL Tools

         2. Reporting Tools

1. ETL Tools:

 1. Informatica 

 2. Data Stage

 3. Abintio

 4. SSIS

 5. ODI

 6. OWB

 7. BODI

2. Reporting Tools:

       1. OBIEE

       2. BI Publisher

       3. Cognos

       4. SAP-BO

       5. DOMO

       6. Qlick View

       7. MSTR

8. What are the differences between OLTP and OLAP?

A.  

OLAP vs OLTP  source: www.rainmakerworks.com