ETL Testing Data Quality - ETL Testing

What is Data Quality?

Data quality checking during ETL testing involves more of performing those quality checks on the data that is loaded in the target system. It includes the below listed tests −

Number check

Number Check involves the checking of the Number format.

It should be same displaying across the target system. For suppose, in the source system, if the format of numbering the columns is x.30, and if the target is only 30, then it has to load without prefixing x. in target column number.

Date Check

The Date format should be consistent all over the table w.r.t both the source and the target systems. For suppose, The Standard format is: yyyy-mm-dd.

Precision Check

Precision value should be displayed as expected in the target table. For suppose, in the source table, if the value is displayed as 15.2323422, then in the target table, it should be displayed as 15.23 or round of 15.

Data Check

Data Check involves checking of data as per the business requirements. In this case, the records which don’t meet our criteria will be filtered out.

For Example − Only those records whose date_id >=2015 and Account_Id != ‘001’ should load in the target table.

Null Check

Some columns in the source table should have Null as per the requirement and possible values for that field.

For Example − Termination Date column should display Null unless and until its Active status Column is “T” or “Deceased”.

Other Checks

Common simple checks like From_Date should not greater than To_Date can be done accordingly.

All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd Protection Status

ETL Testing Topics