Difference between Database testing and ETL testing



ETL Testing
                          Data Base Testing
Verifies whether data is moved as expected
The primary goal is to check if the data is following the rules/ standards defined in the Data Model
Verifies whether counts in the source and target are matching
Verifies whether the data transformed is as per expectation
Verify that there are no orphan records and foreign-primary key relations are maintained
Verifies that the foreign primary key relations are preserved during the ETL
Verifies that there are no redundant tables and database is optimally normalized
Verifies for duplication in loaded data
Verify if data is missing in columns where required



Followers