1.

Write some ETL test cases.

Answer»

Among the most common ETL test cases are:  

  • Mapping DOC Validation: Determines whether the Mapping Doc contains ETL information.
  • Data Quality: In this case, every aspect of the data is tested, including number Check, Null Check, Precision Check, etc.
  • Correctness Issues: Tests for MISSING, incorrect, non-unique, and null data.
  • Constraint Validation: Make sure that the CONSTRAINTS are PROPERLY defined for each table.


Discussion

No Comment Found

Related InterviewSolutions