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.