|Criteria||ETL Testing||Manual testing|
|Basic procedure||Writing scripts for automating testing process||Seeing and testing method|
|Requirements||No need of additional technical knowledge other than software||Need technical knowledge of SQL and shell scripting|
|Efficiency||Fast, systematic and gives top results||Needs time, effort and prone to errors|
ETL refers to Extracting, Transforming and Loading of Data from any outside system to the required place. These are the basic 3 steps in the Data Integration process. Extracting means locating the Data and removing from the source file, transforming is the process of transporting it to the required target file and Loading the file in the target system in the format applicable.
Click here, to learn more about ETL testing process.
Learn ETL Testing in 12 hrs. Download e-book now
ETL Testing Process:
Although there are many ETL tools, there is a simple testing process which is commonly used in ETL testing. It is as important as the implementation of ETL tool into your business. Having a well defined ETL testing strategy can make the testing process much easier. Hence, this process need to be followed before you start the Data Integration processed with the selected ETL tool. In this ETL testing process, a group of experts comprising the programming and developing team will start writing SQL statements. The development team may customize according to the requirements.
ETL testing process is:
Analyzing the requirement – Understanding the business structure and their particular requirement.
Validation and Test Estimation – An estimation of time and expertise required to carry on with the procedure.
Test Planning and Designing the testing environment – Based on the inputs from the estimation, an ETL environment is planned and worked out.
Test Data preparation and Execution – Data for the test is prepared and executed as per the requirement.
Summary Report: Upon the completion of the test run, a brief summary report is prepared for improvising and concluding.
Click here, to check out ETL testing training course.
ETL testing includes
The types of data warehouse applications are:
Click here to learn more about ETL Testing, in this ETL Testing training course.
Download ETL Testing Interview questions asked by top MNCs in 2017 ?
It is a central component of a multi-dimensional model which contains the measures to be analyzed. Facts are related to dimensions.
Types of facts are:
Cubes are data processing units comprised of fact tables and dimensions from the data warehouse. It provides multi-dimensional analysis. OLAP stands for Online Analytics Processing, and OLAP cube stores large data in multi-dimensional form for reporting purposes. It consists of facts called as measures categorized by dimensions.
Click here, to learn more in this ETL Software Testing training.