Question: etl how to extract data?
Answer: In the first step extraction, data is extracted from the source system into the staging area. In the transformation step, the data extracted from source is cleansed and transformed . Loading data into the target datawarehouse is the last step of the ETL process.