Transforming and validating xml type data

Version Informatica 9.1 compatibility We have XML parser transformation with validate option on XML tags and able to send the errors in separate pipe line. Two kinds of validators can be created from a Schema object.XML document An XML document contains elements, attributes, and values of primitive data types. One is Validator, which provides high-level validation operations that cover typical use cases.When I remove the XSD reference in the XML file, effectively removing the data validation, my XPath queries suddenly do work! I've tried adding namespace references to the XSLT but to no avail.I've described the XSD, Sample XL and Sample XSLT below. And of course as soon as you post a question, you find an answer yourself!to the root element of my xml file, the xslt transformation does not work anymore.When I don't specify the xsd-File, the transformation works and the data gets displayed but as soon as I add the xsd-File, no data are getting displayed anymore.The workaround I proposed there and that I also offer you in this case is to enable "Open in Editor" for the output.

Issue We are creating the XML using expression and hard coding the tags of XML. So that we need to validate after generating the XML with client provided new XSD. Version Informatica 8.6 incompatibility We don’t have user friendly validation option except session level validate property against XSD. • Schema Class ο This object represents a set of constraints that can be checked/ enforced against an XML document.

However I've been having issues trying to perform XPath queries to select the data I wish to display in my XSLT.

When I use generic selectors like './/' or '*' I get the results I'd expect.

XSD schema for the above XML document, address.xsd, can be given as follows: The following example shows how to validate XML document against XSD schema by using java. The below code placed in the On Input row tab under the Javacode tab in Java transformation. The below java packages placed in the Import Java packages tab under the Javacode tab in Java transformation. If XML is valid against XSD, then status is assigned as Valid else In Valid. Check the status as ‘In Valid’ in Filter transformation and send error records to target . It reads external representations of schemas and prepares them for validation.

Mapping flow diagram: The above mapping taking XML and XSD file name as input and send a validation status to the target file. Create mapping variable $$XML_FILE and $$XSD_FILE and declare it in your parameter file. Assign the XML, XSD File names along with folder details into the parameters. The following code place on the input row tab in Java transformation 1. The class is capable of locating other implementations for other schema languages at run-time.