An ETL testing includes:

  • Ensure that the ETL application must report in all the invalid data and replace them with a default value.
  • Confirm whether the data is transforming correctly according to the business requirements.
  • Ensure that data loads at expected time frame to improve performance and scalability.
  • Assay the projected data should be loaded into the data warehouse without any loss and truncation.
BY Best Interview Question ON 26 Jan 2019