ETL Validator gives quick and easy way to create test cases for checking mandatory fields. Here, we will create a test case that will identify records from Customers table that have a blank value in ‘First Name’ field and null value in ‘Marital Status’ field.

The slideshow below walks you through creating the test case.

ETL Validator Usecase - Check for Mandatory Fields