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 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.
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 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 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.
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”.
Common simple checks like From_Date should not greater than To_Date can be done accordingly.
ETL Testing Related Interview Questions
|Data Warehouse ETL Toolkit Interview Questions||Manual Testing Interview Questions|
|SQL Interview Questions||Share Point Administration Interview Questions|
|Database Testing Interview Questions||Automation Testing Interview Questions|
|Rational Functional Tester Interview Questions||Embedded Testing Interview Questions|
|Unix/Linux Interview Questions||Radar Test Engineer Interview Questions|
Etl Testing Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.