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
|
Difference between Database testing and ETL testing
