Download - ETL Validator: Flat File Validation
Transcript
<Insert Picture Here>
Validating Flat Files Using ETL Validator
Easy. Fast. Repeatable
Use Case
• As a QA Engineer, I want to validate an
incoming flat file and ensure that the
data is as expected
• Pre Requisite• Successful ETL Validator Login
“Click on
Create Tests”
“Select
Component test
Case”
“Enter Test
Case Name”
“Drag & Drop Flat
File Component”
“Enter Component
Name and Select
File”
“Click On Next”
“Choose Delimiter
and Other Optional
Parameters”
“Define Basic Rules”
“Load Data and
Click on Next”
“Define Complex Rules
(As Needed) for each
Column”
“A number of Pre-Built
Functions Available”
“
“Click On Run”
“View and Analyze
Results”
Other Related Tests
• Compare Flat File to Table
• Compare Flat File to Flat File
• Compare Table to Table