xml input stage
Moderators: chulett, rschirm, roy
xml input stage
Hi
I have converted a dsjob and exported as Xml doc.Iam trying to write coulmn details, key,sql type in separate seq file.
How to get data from XML I/P to Oracle or seq File.
I have used
folder--> Xml I/P--> Seq file.
In Xml input stage, in i/p i have given FileName & record.In O/p i have loaded columns that i have imported using Xml metadata importer and mapped to Seq.file.
Can anyone help me out..
Thanks
I have converted a dsjob and exported as Xml doc.Iam trying to write coulmn details, key,sql type in separate seq file.
How to get data from XML I/P to Oracle or seq File.
I have used
folder--> Xml I/P--> Seq file.
In Xml input stage, in i/p i have given FileName & record.In O/p i have loaded columns that i have imported using Xml metadata importer and mapped to Seq.file.
Can anyone help me out..
Thanks
Re: xml input stage
This seems the same issue (may be duplicate post ?! ) like one
http://www.dsxchange.com/viewtopic.php?t=103093
Please use this to answer.
The XML Meta Data Tool scans XML documents and creates DataStage table definitions from them.
The tool has its own documentation (XML Developer's Guide) and dedicated online help file. Consult these for more details about its operation.
-NB
http://www.dsxchange.com/viewtopic.php?t=103093
Please use this to answer.
The XML Meta Data Tool scans XML documents and creates DataStage table definitions from them.
The tool has its own documentation (XML Developer's Guide) and dedicated online help file. Consult these for more details about its operation.
-NB
Use the following stages.
Folder ---> XML Input ---> Transformer ----> SEQ file.
Whatever columns comes out from XMLInput should pass-through the Transformer stage. In the transformer you might have to convert some invisible characters as follows.
ereplace(ereplace(xmlOP.Column1, char(10) , ""),char(9) , "")
try that way, you would be able to see values in the SEQ file.
- U
Folder ---> XML Input ---> Transformer ----> SEQ file.
Whatever columns comes out from XMLInput should pass-through the Transformer stage. In the transformer you might have to convert some invisible characters as follows.
ereplace(ereplace(xmlOP.Column1, char(10) , ""),char(9) , "")
try that way, you would be able to see values in the SEQ file.
- U
[quote="uegodawa"]First use the DataStage Manager to Load the meta data.
Manager -> Import - > Table def - > XML TAble DEf
Then Open your XML . File -> Open
Then click on all text nodes which you want and save the meta data.
Now goback to your job, open XML Input stage, then output tab , columns, Load.
Then Load the meta data which you saved earlier.
- U
[/quote]
(This quote from the duplicate Post)
Manager -> Import - > Table def - > XML TAble DEf
Then Open your XML . File -> Open
Then click on all text nodes which you want and save the meta data.
Now goback to your job, open XML Input stage, then output tab , columns, Load.
Then Load the meta data which you saved earlier.
- U
[/quote]
(This quote from the duplicate Post)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Can you please double check the properties of your Folder Stage;
Stage->Properties->Folder PathName : Defined the folder where you could find the xml. e.g C:\MyFiles\XML
Outputs->Properties->WildCard : Mention your xml document.
e.g MyFile.xml
In the XML Input Stage->Input -> XML Source Column : Select the second column which is related to XML data ( Where First Coulmn is File Name).
Then you would be able to see the results.
- U
Stage->Properties->Folder PathName : Defined the folder where you could find the xml. e.g C:\MyFiles\XML
Outputs->Properties->WildCard : Mention your xml document.
e.g MyFile.xml
In the XML Input Stage->Input -> XML Source Column : Select the second column which is related to XML data ( Where First Coulmn is File Name).
Then you would be able to see the results.
- U
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: