Test Strategy for ETL Testing / Standard Tests for ETL Testing

There will be some standard tests for DWH that should be carried out as part of testing for every DWH Project.

These are Strategies for testing ETL Applications are Identified as below:

1)      Data Completeness Testing

2)      Data Transformation Testing

3)      Data Quality Testing

4)      Initial Load / Full Load Testing

5)      Incremental Load Testing

6)      Presentation Layer Testing /  BI Testing / Report Testing

7)      Integration Testing / System Integration Testing / SIT

8)      Load and Performance Testing

9)      UAT Testing / User Acceptance Testing

10)   Regression Testing

                     High Level Description

    Data Completeness Testing             -  

Ensures that all expected data is loaded

       Data Transformation Testing            - 

 Ensures that all data is transformed correctly according to business rules

Data Quality Testing -

Ensure that the etl applications correctly rejects,substitutes the default values and reports invalid data

 Initial Load / Full Load Testing -

       Ensures that all the very first time data loaded correctly and als ensure the truncating process

Incremental Load Testing -

       Ensures that after first load all data is getting updating maintaining versioning and inserting new records  properly

  Presentation Layer Testing /  BI Testing / Report Testing  -

Testing BI Reports in DWH testing and comparing data correctness from DWH data and Reports

Integration Testing / System Integration Testing / SIT  -

Ensure that the ETL process functions with other upstream and downstream process

 Load and Performance Testing -

Ensure that the data loads and queries perform within expected Timeframes

 UAT Testing / User Acceptance Testing  -

Ensure that solution  and current expectations and anticipates full expectations

Regression Testing -

Ensures the new data updates have not broken any existing functionality or process.