The different phases of ETL testing are as follows :
Requirement analysis :
Input to start testing is data model and mapping document, we need to make sure that the source table or files provided by developer are correct as per mentioned requirement.
Test planning :
We need to prepare test plan based on requirements. Every company has their own template for test plan.
Test Design :
Test cases will be prepared based on the mapping document and data model.
In this stage we need to analyze source data and mapping documents such as data type, data length and relationships and prepare queries.
Test Execution :
Once the environment setup done, data is available for testing and all the required test scripts is ready then first round of execution can be performed with the bulk load jobs and all the stages from source to target will be tested one by one. During testing if you observe any issue then log a defect.
Defect retesting :
Fixed defects will be re-tested in this phase. Based on impact analysis the test cases need to be executed as part of a defect fix.
Test Closure/Sign off :
Based on the exit criteria of test execution the sign-off mail is to be sent to stakeholders to be proceeded to push the code to the next level.
No comments:
Post a Comment