What is ETL testing and its benefits in testing
Posted By : Anuj Gupta | 30-Jul-2018
ETL is abbreviated from Extract-Transform-Load Testing which is a process of how data is loaded from the source system to the data warehouse.
The data in the Data Warehouse loaded in the ETL form having following operations:
1) Extract – it means pulling out the set of information or data from different types of locations or sources.
2) Transform – it means changing or converting the extracted data into the proper form (by applying several conditions, rules or condition and by removing duplicate data) so that it can be placed in another database.
3) Load – it means to load the transformed data into a Data Warehouse or into the target database for the further use as per the requirement.
Let's discuss more
ETL Testing Process
ETL Testing is similar to other testing processes having the following steps:
1) Requirement Collection: Business Analyst goes to the client's place and understand the requirement and prepare the CRS document as per the client need.
2) Test Planning: It is a document which tells about the future testing activities like test selection tool, cost estimation, resource planning etc.
3) Design and Prepare Test Cases: In this phase, the testing team writes the detailed test cases for the various scenarios which include positive and negative test cases.
4) Test Execution: In this phase, the testing team has to perform testing and prepare the bug report and report it back to the development team for fixing the bug and again, testers re-test the defect fixes and report the status.
5) Test Closure: It is a document which contains the closure report having the detailed analysis of project and bugs fixes and defect found.
Benefits of ELT Testing:
1) Quality of a data: It is essential for making the decisions as it helps to assure that only standard quality and accurate data is saved in the production servers.
2) Avoid the risk of Data Loss: ELT testing helps to avoid the risk factor of data loss.
3) Provides Timely Access: Check the data and provide the access to the user at any time.
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
Anuj Gupta
Anuj is a passionate QA engineer and an optimistic person. He is fond of playing Chess and Basketball. He always comes up with the new ideas and is a good team player.