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.
Responsibilities:
• 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 RequestIn 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 TestingThe 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.
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.
Responsibilities:
• 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 RequestIn 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 TestingThe 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.
.jpg)
Etl testing online training Smart mind provides best online training with live project ETL is brief for extract, transform, load, 3 information functions that are combined into one tool to tug knowledge out of 1 information and place it into another information.ETL systems area unit unremarkably accustomed integrate knowledge from multiple applications, usually developed and supported by totally different vendors or hosted on separate element. The disparate systems containing the initial knowledge area unit often managed and operated by totally different workers. as an example a value register might mix knowledge from payroll, sales and buying. ETL Testing online training.
ReplyDelete