XML Output unable to generate multiple namespaces
Posted: Mon Feb 16, 2015 7:00 am
Hello All,
I am reading data from a table and creating XML blocks and storing in the Oracle target table as BLOB. I am using Oracle Connector Stage ==> XML Output Stage ==> Transformer Stage ==> XML Output Stage ==> Oracle Connector Stage to generate below XML. I am able to generate XML structure and first namespace correctly but unable to generate later three namespaces (I have added comments against *). Can you please let me know how I can generate those namespaces?
=========
<s:ShowStandardCodes xmlns:gwm="http://www.gm.com/2006/GWM" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.starstandards.org/STAR" xsi:schemaLocation="http://www.gm.com/2006/GWM v1.01\GWM_TI_ShowStandardCodes.xsd" revision="3.0" release="8.1-Lite" environment="Production"> * ABLE to generate namespace
<s:ApplicationArea>
<s:Sender xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Sender">...</s:Sender> ** UNABLE to generate namespace
<s:CreationDateTime>2015-01-21T13:29:15.00Z</s:CreationDateTime>
<s:Destination>...</s:Destination>
</s:ApplicationArea>
<s:DataArea>
<s:Show xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Show"/> ** UNABLE to generate namespace
<s:StandardCodes>
<s:Header xmlns:gwm="http://www.gm.com/2006/GWM" xsi:type="gwm:StandardCodesHeaderExtended">...</s:Header> ** UNABLE to generate namespace
========
Additional info :
Expected result for one of the tag :
<s:Sender xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Sender">
Actual result : <s:Sender xsi:type="s:Sender">
Missing part : xmlns:s="http://www.starstandards.org/STAR"
I used below xpath in the Description column :
/s:ShowStandardCodes/s:ApplicationArea/s:Sender[@xsi:type="s:Sender"]/s:Component
Please let me know if you need additional information. Thanks in advance!
Thanks,
-Amit
I am reading data from a table and creating XML blocks and storing in the Oracle target table as BLOB. I am using Oracle Connector Stage ==> XML Output Stage ==> Transformer Stage ==> XML Output Stage ==> Oracle Connector Stage to generate below XML. I am able to generate XML structure and first namespace correctly but unable to generate later three namespaces (I have added comments against *). Can you please let me know how I can generate those namespaces?
=========
<s:ShowStandardCodes xmlns:gwm="http://www.gm.com/2006/GWM" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.starstandards.org/STAR" xsi:schemaLocation="http://www.gm.com/2006/GWM v1.01\GWM_TI_ShowStandardCodes.xsd" revision="3.0" release="8.1-Lite" environment="Production"> * ABLE to generate namespace
<s:ApplicationArea>
<s:Sender xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Sender">...</s:Sender> ** UNABLE to generate namespace
<s:CreationDateTime>2015-01-21T13:29:15.00Z</s:CreationDateTime>
<s:Destination>...</s:Destination>
</s:ApplicationArea>
<s:DataArea>
<s:Show xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Show"/> ** UNABLE to generate namespace
<s:StandardCodes>
<s:Header xmlns:gwm="http://www.gm.com/2006/GWM" xsi:type="gwm:StandardCodesHeaderExtended">...</s:Header> ** UNABLE to generate namespace
========
Additional info :
Expected result for one of the tag :
<s:Sender xmlns:s="http://www.starstandards.org/STAR" xsi:type="s:Sender">
Actual result : <s:Sender xsi:type="s:Sender">
Missing part : xmlns:s="http://www.starstandards.org/STAR"
I used below xpath in the Description column :
/s:ShowStandardCodes/s:ApplicationArea/s:Sender[@xsi:type="s:Sender"]/s:Component
Please let me know if you need additional information. Thanks in advance!
Thanks,
-Amit