Extraction is the first step of the ETL(Extract, Transform and Load) process. Once the data is extracted, you can transform it and load to target data warehouse. Extraction is the process of extracting data from the source system for further use in the data warehouse environment. Related Reading: Data Warehouse Fact Constellation Schema and Design Star Schema model in Data Warehouse Snowflake Schem Model in Data Warehouse Data warehouse is an OLAP system, typically source system includes the transaction business processing application. For example, it could be sales order entry…