Types of ETL Testing
ETL testing is classified into four different sections irrespective of technology or the ETL tools used:
1. New Data Warehouse Testing
It is built and verified from the scratch. In this case the data input is taken from the customer requirements and different data sources and new data warehouse is build and verified with the help of ETL tools.
• Business Analyst gathers and documents the requirements
• Infrastructure people sets up the test environments
• QA Testers develop and then execute the test plans and test scripts
• Developers perform unit tests of each modules
• Database Administrators test for the performance and also for the stress
• Users do functional tests including UAT (User Acceptance Tests)
2. Migration Testing
In this case customer will have an existing data warehouse and ETL performing the job. But customers are looking to bag new tool to improve efficiency. It includes these following steps:
Design and validation test
Setting up the test environment
Executing the validation test (it depends on test design and data migration process)
Reporting the bugs
3. Change Request
In this case new data is added from various sources to an existing datawarehouse. There might be a condition where customer requireschanging their present business rule or they might integrate new rule.
4. Report Testing
The reports are the end result of Data Warehouse. Reports must be tested by validating data, layout in the report.Reports are an important resource for creatingvital business decisions, from the basic reports to all sorts of drilldown reports that let users slice and filter data the way they need.
There is a great demand for ETL testing training. Many young professionals are intended to optETL testing online training, because they do not have much time to join classroom training. There are several training institutes which are offering ETL testing training. We provide ETL testing online training to the aspirants. After completion of your course you can join as Junior Tester. If you are interested to learn ETL testing, call us today for our free demo classes on ETL testing online training.