1.

Write the difference between ETL testing and database testing.

Answer»

Data validation is involved in both ETL testing and database testing, however, the two are different. The ETL testing PROCEDURE normally involves analyzing data stored in a warehouse SYSTEM. On the other hand, the database testing procedure is commonly used to analyze data stored in transactional systems. The following are the distinct differences between ETL testing and Database testing. 

ETL Testing Database Testing 
The ETL process is used to test data extraction, transformation, and loading for BI reporting purposes.  Data is validated and integrated by performing database testing. 
Data movement is being CHECKED to determine if it is going as expectedThis test is primarily designed to verify that data follows the rules or standards defined in the Data Model.  
It verifies whether the counts and data in the source and target match or not.  It ensures that foreign key relationships are maintained and no orphan records are present, as well as that a column in the table has valid values. 
This technique is applied to OLAP systems.  This technique is applied to OLTP systems. 
The approach utilizes denormalized data with fewer joins, more indexes, and more aggregates.  The approach utilizes normalized data with joins. 
Some of the most common ETL tools are QuerySurge, Informatica, Cognos, etc. Some of the most common database testing tools are Selenium, QTP, etc. 


Discussion

No Comment Found

Related InterviewSolutions