Which of the following describes ETL?
Which of the following describes ETL?
a. A process that transforms information using a common set of enterprise definitions
b. A process that extracts information from internal and external databases
c. A process that loads information into a data warehouse
d. all of the above
The correct answer: “d” i.e. all of the above
ETL is an acronym for three database functions extract, transform, load that is combined into one tool to extract the data from a database and load it into another database.
Extract is the process of reading data from internal and external databases
Transform is the process of converting the extracted data into the form required form.
Load is the process of loads information into the target database.
Note:
ETL is an acronym for three database functions extract, transform, load that is combined into one tool to extract the data from a database and load it into another database.