Advanced ETL Processor verifies file layout with the Validator by checking fields against rules before the import continues. Use it when a text or spreadsheet file must match expected columns, formats, lengths, dates, numbers, or required values. A file layout check is cheaper than loading bad data and then pretending the database did it.
What You Will Learn
- Add Validator checks before the import target.
- Check required fields, formats, dates, numbers, and patterns.
- Reject or discard rows that do not match the expected layout.
- Debug validation rules with sample file rows before automation.
Before You Start
Use a sample file that includes good and bad rows. If every row is perfect, the Validator cannot prove much, and production files rarely behave that politely.
File Layout Validation Docs
The Validator documentation explains how validation rules check incoming data before it reaches the Writer or import target.
Start with What is Data Validation for data type, range, format, pattern, consistency, and referential checks. These are the checks that catch layout problems before rows are loaded.
The Validator Screen section explains that Validator output fields match the inputs. That matters for layout checks because the object validates rows rather than reshaping the file.
Use the Validator Toolbar and Debugging Validation sections to process sample rows, edit test values, and inspect rule behaviour before scheduling the import.
For rule details, use Validation Rules plus the dedicated docs for strings, numbers, dates, and regular expressions.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.