I have a xml file that needs to be loaded into a seq file for further transformations. I'm unable to get any output from the XML Input stage.
My first stage is a sequential file stage where I have specified a column name "Input" as LongVarChar. This is followed by a XML Input stage and a target Sequential file.
In the input tab of the XML Input stage, I choose the following-
XML source column = "Input"
Column content = XML document
In the output tab of XML Input stage, I choose one o/p column as a repetition element.
I also gave a reject link to the XML Input stage. When I run this job, no rows are loaded into the target sequential file and many rows are rejected. When I try to view the data in the reject file, it shows the following error -
XML input document parsing failed. XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 6): There are more end tags than start tags
Please help.
Loading XML file data into a Seq. file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How to provide 2 or more Repetition Keys in XML input stage?
ok as u said I used folder stage but I am facing new problem
I have used a XML input stage to extract data from a XML file to a sequential file. In th XML input stage, I have the option of providing only a single repetition key.
How can I provide multiple repetition keys in the XML input stage as I have more than 1 primary key in the XML file?
Please help.
I have used a XML input stage to extract data from a XML file to a sequential file. In th XML input stage, I have the option of providing only a single repetition key.
How can I provide multiple repetition keys in the XML input stage as I have more than 1 primary key in the XML file?
Please help.