What is Extract Transform Load
Posted By : Rashmi Verma | 09-Jun-2016
What is ETL ?
ETL stands for "Extract-Transform-Load" and it define the process how data is loaded from source system to the data warehouse. In this Data is extracted from OLTP online transaction processing database, it transformed to match the data warehouse schema and loaded into the data warehouse database. Data warehouses also combine data from non-OLTP systems like text files, preadsheets, legacy systems. ETL can Transform dissimilar data set into the unified data set.
ETL Process -
Extract - Extract data from the source system
Cleaning of data - After data extraction it move to the cleaning and conforming phase . In the cleaning phase error are identify and fixing the error. In the conforming phase resolve the conflicts between those data’s that is incompatible, so that they can be used in an enterprise data warehouse.
Transform - In this data is transform in the dataware house format. It also builds the keys datawarehouse owns keys(primary, alternate key, foreign key, composite key) and never allows any other entity to assign them.
Load - Load data into the warehouse and creating an aggregate is summarizing and storing data which is available in fact table in order to improve the performance of end-user queries.
ETL testing is performed in five stages
- Identifying data sources and requirements
- Data acquisition
- Implement business logics and dimensional Modelling
- Build and populate data
- Build Reports
THANKS
Cookies are important to the proper functioning of a site. To improve your experience, we use cookies to remember log-in details and provide secure log-in, collect statistics to optimize site functionality, and deliver content tailored to your interests. Click Agree and Proceed to accept cookies and go directly to the site or click on View Cookie Settings to see detailed descriptions of the types of cookies and choose whether to accept certain cookies while on the site.
About Author
Rashmi Verma
Rashmi is a ISTQB Certified QA Engineer and with skills in Testing.