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

Question

Quizplus · Accepted Answer

Extraction, Transformation, and Loading (ETL) is a process used in database usage and data warehousing that involves extracting data from outside sources, transforming it to fit operational needs (which can include quality levels), and loading it into the end target database or data warehouse.

What Is Extraction, Transformation, and Loading