Anonymous Asked in Cars &Transportation · 2 weeks ago

Which of the following is approach of data warehousing?

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. 7 дек. 2021 г.


What is top-down approach in data warehousing?

In the "Top-Down" design approach, a data warehouse is described as a subject-oriented, time-variant, non-volatile and integrated data repository for the entire enterprise data from different sources are validated, reformatted and saved in a normalized (up to 3NF) database as the data warehouse.

What is Kimball and Inmon approach?

Kimball uses the dimensional model such as star schemas or snowflakes to organize the data in dimensional data warehouse while Inmon uses ER model in enterprise data warehouse. Inmon only uses dimensional model for data marts only while Kimball uses it for all data.

What are the 4 key components of a data warehouse?

A typical data warehouse has four main components: a central database, ETL (extract, transform, load) tools, metadata, and access tools. All of these components are engineered for speed so that you can get results quickly and analyze data on the fly. Diagram showing the components of a data warehouse.

What are the three types of data warehousing?

The three main types of data warehouses are enterprise data warehouse (EDW), operational data store (ODS), and data mart.

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours