Iam finding difficulties in reading a simple XML data.
Let the following be the data.
Code: Select all
<?xml version="1.0" encoding="ISO-8859-1"?>
<EMP>
<Record sino="1" name="Mark" sal="100.00" />
</EMP>
Job design is as follows.
Sequential file stage with Varchar 255 to read the XML.
Pass it to XML Input stage. Column content as XML_document. Output tab loaded with the requried table definiton.
And output to a sequential file with .txt format.
Any further settings to be made?
It gives out the following warning and error.
Code: Select all
XML_Input_20,0: Error: Cannot find mandatory property "xml_source_column".
XML_Input_20,0: Error occurred in call to ORPHCallActivePluginInitialize().