^{PDFprof.com Search Engine}

Building the Data Warehouse

What is the concept of building a data warehouse?
A Data Warehouse is Built by combining data from multiple diverse sources that support analytical reporting, structured and unstructured queries, and decision making for the organization, and Data Warehousing is a step-by-step approach for constructing and using a Data Warehouse.
What is the approach to building a data warehouse?
There are 2 approaches for constructing data-warehouse: Top-down approach and Bottom-up approach are explained as below.
External source is a source from where data is collected irrespective of the type of data.
Data can be structured, semi structured and unstructured as well.
What are the steps involved in building data warehouse?
How to build a data warehouse in 7 steps:
1Elicit goals.
2) Conceptualize and select the platform.
3) Create a business case and develop a project roadmap.
4) Analyze the system and design the data warehouse architecture.
5) Develop and stabilize the system.
6) Launch the solution.
7) Ensure after-launch support.
8 Steps in Data Warehouse Design
Defining Business Requirements (or Requirements Gathering) Setting Up Your Physical Environments. Data Warehouse Design: Introducing Data Modeling. Choosing Your Extract, Transform, Load (ETL) Solution. Online Analytic Processing (OLAP) Cube. Data Warehouse Design: Creating the Front End.

What is the concept of building a data warehouse?