TYPES OF ETL TESTING

METADATA TESTING

     1)      DATA TYPE CHECK

     2)      DATA LENGTH CHECK

     3)      INDEX/CONSTRAINT CHECK

     4)      METADATA NAMING STANDARDS CHECK

     5)      METADATA CHECK ACROSS ENVIRONMENTS

DATA COMPLETENESS CHECKING

DATA ACCURACY CHECKING

DATA TRANSFORMATION TESTING

INCREMENTA ETL TESTING

VALIDATION TESTING