Component Test Case of ETL Validator helps with testing such scenarios. It is intuitive, easy and flexible to create. As per requirement, it can be extended to cover elaborate or complex scenarios.