Flat File Testing Capabilities
Simplifies data comparison between Flat files and database. Provides capability to define rules for automatically validating data in each column in the incoming file. Has a builtin File Watcher that automatically detects new files coming to a folder and kicks off tests
Data Quality Testing
Provides a Data Model driven interface for defining rules to test data validity, data accuracy and referential integrity. This helps verify that the data conforms to standards and range of values.
Database Metadata Testing.
Helps audit changes to the database metadata - data types, lengths, indexes. Simplifies comparison of database schema across environments. Compares data types between source and target.
OLAP/BI Testing Automation
ETL Validator enables comparison of the output from an OLAP/BI query with data output from a SQL Query or flat file. This allows for end-to-end testing of reports with the source data.