Flatfiles Validations

When we are extracting the flatfiles, What are the basic required validations?

Questions by greek143

Showing Answers 1 - 3 of 3 Answers

Folllowing are some common validations performed:
a) Check for blank lines and remove them.
b) Check the number of column in each row of the file.
c) If there is a  trailer line in the flat file containing additional information like total number of records,then a cross check is performed to check if the number of records specified in the trailer and the actual number of records are same.
d) Check if a column contains balnk value (If it is expected to have values).

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions