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 about ETL Testing.

 

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. 

 

Related Tags

About Author

Author Image
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.

Request for Proposal

Name is required

Comment is required

Sending message..