Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is ETL, Extract Transform and Load?

April 26, 2017ETL Extract load transform

0

Posted

What is ETL, Extract Transform and Load?

1 Answer

0

Posted

ETL is an abbreviation of the three words Extract, Transform and Load. It is a process to extract data, mostly from different types of system, transform it into a structure that’s more appropriate for reporting and analysis and finally load it into the database. The figure below displays these steps. But, today, ETL is much more than that. It also covers data profiling, data quality control, monitoring and cleansing, real-time and on-demand data integration in a service oriented architecture (SOA), and metadata management.