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.
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.