To create XML data which stages to use.
Posted: Mon Dec 17, 2012 4:46 pm
Hi,
I have to load a flat file which has 4 key columns and around 50 data columns. I would like to load this into a table that has 4 key columns and
one xml column. I would like to load all the 50 columns data in to this single xml column.
For doing that when I see IBM documentation I see 2 pdfs one for xml pack (XML Input, XML Output, XML Transformer) and the other is XML transformation guide for new XML stage.
Note: I am using DataStage 8.7 and got basic concepts about XML,XSD,XSLT.
Please let me know which stages would I have to use to accomplish the task.
Is it XML pack (XML Input, XML Output, XML Transformer) or the new XML stage?
Please let me know the steps also?
I have to load a flat file which has 4 key columns and around 50 data columns. I would like to load this into a table that has 4 key columns and
one xml column. I would like to load all the 50 columns data in to this single xml column.
For doing that when I see IBM documentation I see 2 pdfs one for xml pack (XML Input, XML Output, XML Transformer) and the other is XML transformation guide for new XML stage.
Note: I am using DataStage 8.7 and got basic concepts about XML,XSD,XSLT.
Please let me know which stages would I have to use to accomplish the task.
Is it XML pack (XML Input, XML Output, XML Transformer) or the new XML stage?
Please let me know the steps also?