tFileInputMSXML Question?

One Star

tFileInputMSXML Question?

Hi there,
I have 3 questions relating to the use of the tInputMSXML component.

1. Does it parse a file only once or does it do a pass to retrieve each of the schemas defined in the component.
e.g. In the screenshot attached, would the file be parsed once or is it parsed 3 times.
2. Is it possible to validate our xpath query against an XSD file? At the moment, if there is an error typed in to the xpath query no error will be thrown when we run the job.
3. In general is it adviseable to use this on very large xml documents that potentially contain hundreds and hundreds of values to parse.
See screenshot attached: msxml-screenshot.JPG
For a working example of the job you can retrieve it from the following link: 9405

Thanks
One Star

Re: tFileInputMSXML Question?

Bump Smiley Happy
Employee

Re: tFileInputMSXML Question?

Yes, there is a way is you create each Schema with the XML metadata wizard and if you pass the XSD as file input of this wizard.
One Star

Re: tFileInputMSXML Question?

If I can add to that:
A)Are there any examples of how to do this?

B) Also in relation to point 1 in my original post, does the xml file only get parsed once?

Thanks for the help Smiley Happy
Community Manager

Re: tFileInputMSXML Question?

Hello guy
A)Are there any examples of how to do this?

Here is an example 7779.
B) Also in relation to point 1 in my original post, does the xml file only get parsed once?

The file will be parsed only one time.
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business