Explain what are the ETL testing operations includes?

ETL testing includes

  • Verify whether the data is transformed correctly according to business requirements
  • Verify that the projected data is loaded into the data warehouse without any truncation and data loss
  • Make sure that ETL application reports invalid data and replaces with default values
  • Make sure that data loads at expected time frame to improve scalability and performance