Level 2 Quiz

Pulling data from different source systems.

Transmitting and loading data to the receiving end.

The process of extraction,

transformation and loading during database use.

The simplest and least costly architecture alternative. The data marts are developed independently of each other.

Transforming data into an understandable format, where data is typically stored together with an error detection and correction code to meet operational needs.

Similar to hub and spoke except that there are no dependent data marts. Instead, it has a very large data warehouse that serves all the needs of the organizational units.

Focuses on building a scalable and maintainable infrastructure. It allows easy customization of user instances and reports.

Uses all the possible ways to integrate analytical resources from multiple sources to meet changing needs or business conditions.

A bus architecture is composed of a set of tightly integrated data marts that get their power from conformed dimensions and fact tables.

Formerly known as Business Dimensional(BI) Lifecycle.