Question

6. Identify and briefly describe the steps in the ETL process. What is the goal of the ETL process?

Answer 1

6. ETL is the complete process where data is Extracted, Transformed and Loaded in to a different database or table from a source which is required for use for data analysis or business purpose as well. It is a collective or single process which possess all the steps:

Extraction - the data is extracted from the source

Transformation - the data extracted from the source is transformed based on the requirement of the business.

Load - finally after all the transformation are applied, the data us them loaded to the the target.

The Goal of the ETL process is to ensure data is copied from one source to another considering the business logic.