A company wants to consolidate its data from multiple databases, flat files, and cloud sources into a single data warehouse. Which phase of the ETL process will handle the collection of this data?

  • Extraction
  • Integration
  • Loading
  • Transformation
In the ETL (Extract, Transform, Load) process, the first phase is "Extraction." This phase is responsible for gathering data from various sources, such as databases, flat files, and cloud sources, and extracting it for further processing and storage in a data warehouse.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *