Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
|
Question 643
|
__________ allows selection of the relevant information necessary for the data warehouse.
|
The Top – Down View
|
|
|
Data Warehouse View
|
|
|
Datasource View
|
|
|
Business Query View
|
Question 643 Explanation:
→ Top-Down is also known as Inmon’s Top Down Approach, data warehouse is built first. Inmon defines a data warehouse as a centralized repository for the entire enterprise. Dimensional data marts are created only after the complete data warehouse has been created.
→ Bottom-Up is also called as Kimball’s bottom up approach, the most important business aspects or departments, data marts are created first. A data mart provide a thin view into the organisational data and addresses a single business area. These data marts are then integrated into larger data warehouse to build a complete data warehouse. The integration of data marts is implemented using Kimball’s data warehousing architecture which is also known as data warehouse bus (BUS).
→ Bottom-Up is also called as Kimball’s bottom up approach, the most important business aspects or departments, data marts are created first. A data mart provide a thin view into the organisational data and addresses a single business area. These data marts are then integrated into larger data warehouse to build a complete data warehouse. The integration of data marts is implemented using Kimball’s data warehousing architecture which is also known as data warehouse bus (BUS).
Correct Answer: A
Question 643 Explanation:
→ Top-Down is also known as Inmon’s Top Down Approach, data warehouse is built first. Inmon defines a data warehouse as a centralized repository for the entire enterprise. Dimensional data marts are created only after the complete data warehouse has been created.
→ Bottom-Up is also called as Kimball’s bottom up approach, the most important business aspects or departments, data marts are created first. A data mart provide a thin view into the organisational data and addresses a single business area. These data marts are then integrated into larger data warehouse to build a complete data warehouse. The integration of data marts is implemented using Kimball’s data warehousing architecture which is also known as data warehouse bus (BUS).
→ Bottom-Up is also called as Kimball’s bottom up approach, the most important business aspects or departments, data marts are created first. A data mart provide a thin view into the organisational data and addresses a single business area. These data marts are then integrated into larger data warehouse to build a complete data warehouse. The integration of data marts is implemented using Kimball’s data warehousing architecture which is also known as data warehouse bus (BUS).