Question

Arrange the steps in the order in which data transitions from database to data warehouse.

Extract data from the database.
Format data in staging area.
Enter transaction into the database.
Load data into the data warehouse.
Generate reports.

Answer 1

The steps in the order in which data transitions from a database to a data warehouse are: extracting data from the database, formatting data in a staging area, loading data into the data warehouse, and generating reports.

Step-by-step explanation:

1. Extract data from the database.
2. Format data in staging area.
3. Load data into the data warehouse.
4. Generate reports.