In database testing normally data is consistently injected from uniform sources while in data warehouse testing most of the data comes from different kind of data sources which are sequentially inconsistent.

We generally perform only CRUD (Create, read, update and delete) operation in database testing while in data warehouse testing we use read-only (Select) operation.

Normalized databases are used in DB testing while demoralized DB is used in data warehouse testing.

There are number of universal verifications that have to be carried out for any kind of data warehouse testing. Below is the list of objects that are treated as essential for validation in ETL testing:- Verify that data transformation from source to destination works as expected- Verify that expected data is added in target system- Verify that all DB fields and field data is loaded without any truncation- Verify data checksum for record count match- Verify that for rejected data proper error logs are generated with all details- Verify NULL value fields- Verify that duplicate data is not loaded- Verify data integrity

Nice article i was really impressed by seeing this article, it was very intresting and it is very useful for ETL Testing Learners.. I came to know that 123trainings is also one of the best ETL Testing Online Training institute at hyderabad.