Database Testing and Data Warehouse Testing through ETL testing training

There is an accepted misunderstanding that database and data warehouse testing is similar while the verity is that both hold different direction in testing.

  • Database testing is done using lesser amount of data normally with OLTP type of databases while data warehouse testing is done with big quantity of data connecting OLAP databases.
  • In database testing normally data is constantly inserted from consistent sources while in data warehouse testing most of the data comes from many kinds of data sources which are consecutively inconsistent.
  • We usually execute only CRUD (Create, Read, Update and Delete) operation in database testing while in data warehouse testing we use read-only operation.
  • Standardized databases are used in database testing while deflated database is used in data warehouse testing.

There are many numbers of universal verifications that have to be accepted out for any kind of data warehouse testing. Below is the listing of objects explained in online ETL Testing training which is performed as fundamentals for validation in ETL Testing:

Validating to facilitate the data transformation from source to destination works as estimated

  Verify that projected data is added in target system

  Verify that all database fields and field data is loaded not including any truncation

  Verify data checksum for verification count match

  Verify that for discarded data appropriate error logs are generated with all details

  Verify NULL value fields

  Verify that the ravage data is not loaded

  Verify data reliability

Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+