ETL Test Scenarios

Below scenarios are validated as a part of ETL testing :

Table structure verification :

The column name, data type and data length of the target table will be verified against the requirement
constraint’s check. We ensure that all required constraints are available.

Index check :

We ensure that the index are created with the required columns.

Source data validation :

Record the source table count and ensure that there won’t be any junk or bad data exits.

Data count check :

Comparing the target data count against the source data count along with business logic.
Ensure that source data moved correctly to the target table by comparing data.

Duplicate data validation :

Ensure that the duplicate records are not present in source and target table.

Data with primary key and foreign key check :

Test the primary key and foreign key relationship with different test data for the parent and child table.

Null check :

Inject the data with NULL for a NOT NULL column and verify that data will be rejected.

Also check whether data present in source but if null in target.

Data precision check :

Create test data in the source table with different precisions and ensure the loaded data has precision as per requirement.

Date format check :

All date columns are loaded in the defined date format or not.