topic Re: Flat File Validation Framework API in Java in Talend Studio

Flat File Validation Framework API in Java

Anonymous — Sat, 16 Nov 2024 13:20:04 GMT

Hi,
Is there any already available framework/API in java for flat file (Schema and data) validation .
I look for some validation framework like the following mentioned
1) The structure of file, data type, size, "null/not null" type of metadata should be defined some where like in an XML file.
2)The provided API should have method to pass a input record and valivate all the provided fields in the record
3) Invalid record information should be placed in a log ( text file, xml file, database)
I would be using this in java code as well as in other commercial ETL tools.

Thanks and Regards,
Pravu Mishra

Re: Flat File Validation Framework API in Java

Anonymous — Wed, 28 Jul 2010 04:11:45 GMT

Hi
It seems the tschemaComplianceCheck component can finish the request mentioned 1,2,3.
Best regards
Shong

Re: Flat File Validation Framework API in Java

Anonymous — Wed, 28 Jul 2010 06:24:14 GMT

Hi shong,
The tschemaComplianceCheck can only be used in ETL jobs developement using TOS. I need to an API or Framework to use in other java applications, and ETL tools other than TOS. Hope it make sence.
Thanks and Regards,
Pravu Mishra.

Re: Flat File Validation Framework API in Java

_AnonymousUser — Mon, 07 Oct 2013 07:42:16 GMT

Hi pravu,
I too have similar requirment. Please let me know if you got any solution.
Thanks.
-Pinky