Data transformation process
Data Extraction Data analysis starts with a company's raw transactional and operational data. Data Sources are single or many data storage locations like Cloud, ERP, Datawarehouse, flat files, etc. Collecting and extracting data is the initial stage in an ETL process (extract, transform, and load). The goal of ETL is to prepare data for analysis or business intelligence (BI). There are 2 types of data extraction methods: Data transformation process · Logical Extraction:. It is the first step in creating a physical data extraction plan. o Full Extraction : Data copied from the source system in its entirety, even if untimestamped. o Incremental Extraction : This method extracts data in increments. Timestamps can monitor new or changed data. · Physical Extraction Extract data from the source system logically or physically. o Online Extraction : The staging area processes data directly from the source system. o Offline Extraction