Data warehouses are usually built on multi-tier architectures with multiple data extraction and insertion jobs between two data bases. The nature of data changes when they pass from one tier to another. Data Validation is a process of comparing records across different databases to ensure that the data is consistent