Research Article
How is Extraction important in ETL process?
Sweety Patel1*,Mrudang D. Pandya21Department of Computer Science, Fairleigh Dickinson University, USA
2Ganpat University, Ganpat Vidyanagar, Mehsana, Gujarat, INDIA
- *Corresponding Author:
- Sweety Patel
Department of Computer Science, Fairleigh Dickinson University, USA
E-mail: sweetu83patel@yahoo.com
Abstract
In ETL there are three main phase: Extraction, Transformation, Loading. Where all process stands on Extraction as to extract a data from different databases to one database required most of the work done to be in correct direction as it is hard to work on the incorrect data with all wastage of time, cost and also human efforts. So extraction of data is also main important thing to be delivered to the database as it is a foundation for all other phases of ETL cycle. Extraction process is described in detail in the paper.