(a) Define the concept and goal of the Extraction, Transformation, and Loading (ETL) functionality in relation to the Data Warehouse (DW) solution. As part of your answer, briefly explain what problems ETL should address and resolve.
(b) Using a labelled diagram, demonstrate the steps of the ETL operation as implemented in a typical DW. Pay special attention to the double flow of data and Meta-data.