What Is Extraction, Transformation, and Loading

question 95

Multiple Choice

What is extraction, transformation, and loading?

• A) It is a process of entering data, tracking data, and loading it into a database
• B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
• C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube
• D) It is a process that is performed at the beginning of the data mining model

---

Definitions:

Year 1

Refers to the first year in a given time series, fiscal period, or timeframe under consideration.

Absorption Costing

An accounting approach that includes all manufacturing costs (direct materials, direct labor, and both variable and fixed overhead) in the cost of a product.

Operating Income

The profit realized from a company's everyday business operations, calculated by subtracting operating expenses from gross profit.

Year 1

Typically refers to the first year of operation or the initial year in a set period under review or analysis.