What is Data Validation??
Informatica Data validation helps in completing the data validation and reconciliation work in Production and testing without the use of tedious SQL queries. We might come across duplicate and bad data while doing data migrations and transformations. Data validation avoids these bad data and can be used in both Production as well as testing environment. It has got a set of pre built operator for doing ETL testing and the results will be expected data values as from source.
Data validation makes data more reliable, trustworthy and uses less resource for the testing process. This can be automated and used repeatedly. Below are some other features of Informatica Data validation