Explain a few test cases in ETL testing.
There are many test cases available for ETL testing. Here are few best examples for consideration,
- Correctness Issues: Use to test inaccurate data, misspelled data and null data.
- Data Check: Aspects regarding the data such as Number Check, Data Check, Null Check are tested in this case.
- Mapping Doc Validation: Verifies the ETL information present in the Mapping Doc.