validate file

Nagac · Post by **Nagac** » Wed Jul 27, 2011 8:50 am

Hi

How do we validate the flat file whether the files are having headers, Trailers and Details. If any one is not there, job should get aborted.

Could anyone advise how do we implement this?

pandeesh · Post by **pandeesh** » Wed Jul 27, 2011 9:02 am

Can you please post the sample data with header,trailer and details?

ray.wurlod · Post by **ray.wurlod** » Wed Jul 27, 2011 5:06 pm

What do you mean by "validate"? Do you have specifications?

Nagac · Post by **Nagac** » Thu Jul 28, 2011 4:32 am

ray.wurlod wrote:What do you mean by "validate"? Do you have specifications?

I need to check the file whether it has HEader/Trailer. As File has identifiers for each type of row. Eg: Header identifier : H as first character
Trailer:T
Details:D

I will post the sample data, i dont have it right now.

chulett · Post by **chulett** » Thu Jul 28, 2011 6:57 am

Why not script this if all this is is a validation step? If the validation fails, don't run the processing job. Between a count of the total records in the file and a check to see how many records start with "H" and "T", you should be able to whip something up.

Use a Sequence job to run the validation and take the appropriate steps afterwards based on the results.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 28, 2011 4:41 pm

If file has one header and one trailer this is a trivial task to script. If the file might have multiple headers and trailers, the best solution is probably a DataStage job.