The aim of the diploma thesis is to present the framework for system testing
of the ETL process.
ETL is a process that transfers data between different systems of records.
It first downloads the data from the source, converts it into the appropriate
form and uploads it to the target system of records. ETL process actually
receives a certain state on a source system of records as input and changes it
into another system of records as an output. At the system level, the ETL
process is tested by changing and checking the state (data) on the system of
records before and after starting the ETL process. The framework for system
testing is divided into a core and an external part. The core executes the test
scenario, while the outer part manages the systems of records. The frame-
work is designed as expandable as it supports addition of various systems of
records. Architecturally it is similar to the ETL process, but it is simpler
as it is used for testing only. The framework is inserted into a continuous
integration tool, which resulted in faster retrieval of test results.
The result of the thesis is a testing framework that helps the development
team to faster detect errors in the ETL process.
|
