Multiple choice technology

Majority of work involved in a data warehousing project is carried out in this phase

  1. Requirements gathering

  2. Data warehouse design

  3. ETL

  4. Data warehouse testing
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ETL (Extract, Transform, Load) typically consumes 60-70% of a data warehousing project's time and resources. This phase involves extracting data from multiple source systems, transforming it (cleaning, standardizing, calculating), and loading it into the warehouse. The complexity comes from diverse source systems, data quality issues, business logic implementation, and ongoing maintenance. Requirements gathering is important but less time-consuming. Design and testing, while critical, don't match ETL's volume.

Keep practicing — related questions