What is data warehouse development?
Data warehousing is the process of developing, managing, and securing the electronic storage of data by a business or organization in a digital warehouse.
What are the development approaches to data warehouse?
Developmental Approaches At present there are two main competing approaches being advocated for data warehouse development: top-down and bottom-up. In addition, independent data mart and the federated architecture approach are two other approaches that are also applied for data warehouse development today.
Which environment is the source of all data warehouse data?
| Q. | The source of all data warehouse data is the____________. |
|---|---|
| B. | informal environment. |
| C. | formal environment. |
| D. | technology environment. |
| Answer» a. operational environment. |
What are the steps in designing a data warehouse?
8 Steps to Designing a Data Warehouse
- Defining Business Requirements (or Requirements Gathering)
- Setting Up Your Physical Environments.
- Introducing Data Modeling.
- Choosing Your Extract, Transfer, Load (ETL) Solution.
- Online Analytic Processing (OLAP) Cube.
- Creating the Front End.
- Optimizing Queries.
- Establishing a Rollout.
Why a data warehouse is an environment not a product?
) A data warehouse is not a single software or hardware product that provide the strategic information. It is a computing environment where the users can find strategic information, an environment where the users are put directly in touch with the data to make better decisions. It is a user centric environment.
In which environment can you update data data warehouse data mining informational operational?
Data Warehousing with Real-Time Updates Master data in the data warehouse environment is usually maintained with updates from the operational systems or master data environment rather than snapshots of the entire set of data for each periodic update of the warehouse.