Explain the ETL testing operations.
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.