The test plan should state the purpose for each test and show a schedule for running the tests in a predefined sequence. It should also describe the test cases, including input criteria and expected output results. A test log should accompany the test plan, documenting when the tests were run, who ran the tests, and what the test results were.
ETL programs
All extract, transformation, and load programs and scripts for the entire ETL process should be coded and tested. If an ETL tool is being used, instructions for the ETL tool modules should be written and the ETL tool modules should be tested .
ETL program library
All ETL programs, scripts, and ETL tool modules should reside in a version-controlled ETL program library or ETL tool library. These ETL programs, scripts, and ETL tool modules should have been integration or regression tested, performance tested, QA tested, and acceptance tested for the entire ETL process.
