ETL Testing scenarios

ETL Testing scenarios:

 

1.       Table structure validation (Source & Target)

2.       Validate constraints

3.       Data consistency check

4.       Data completeness validation

5.       Data correction validation

6.       Data Transform validation

7.       Data quality validation

8.       Null validation

9.       Duplicate validation

10.   Data validation check

11.   Data cleaning