File Validation Logic
Posted: Tue Dec 27, 2016 8:55 am
Hi all,
Can you please help me with the logic for the following requirement
Source - Sequential File
Target1 (Database) - if all rows validate as OK
Target 2 (Sequential File) - if 1 or more rows validate as Non OK
After read a delimited file and validated, if 1 or more rows Non OK, all rows from source file should be moved to a bad file, adding the rejection reason for the bad rows.
The validation includes datatypes, range of values, number of delimiters.
If the all rows be OK, persists all rows in database.
Also, in the end of the process, is required update the file status in database as OK or Failed.
Thanks in Advance
Can you please help me with the logic for the following requirement
Source - Sequential File
Target1 (Database) - if all rows validate as OK
Target 2 (Sequential File) - if 1 or more rows validate as Non OK
After read a delimited file and validated, if 1 or more rows Non OK, all rows from source file should be moved to a bad file, adding the rejection reason for the bad rows.
The validation includes datatypes, range of values, number of delimiters.
If the all rows be OK, persists all rows in database.
Also, in the end of the process, is required update the file status in database as OK or Failed.
Thanks in Advance