ETL Validator gives quick and easy way to create test cases for checking field format or identifying invalid data. Here, we will create a test case that will identify records from Countries table that have numeric value instead of text value in ‘country_iso_code’ field. And second use case looks for invalid date in ‘promo_begin_date’ field of Promotions table.

The slideshow below walks you through creating the test cases.

ETL Validator Usecases - checking for valid field and data format