Hi,
I am trying to load data from oracle table to xml file in ODI 12.2.1.4 and used below lkm and ikms
LKM SQL TO SQL
IKM XML control append
Layout is not created as per the requirement namespaces alias were created as ns1,ns2,ns3 etc . and namespaces in soap envolope element are renamed.
CUSTREQ.txt
Please find attached expected target XML file layout.
XML format output created:-
<?xml version="1.0" encoding="UTF-8"?>
<Envelope xmlns="soapenv" xmlns:v="v1" xmlns:ns1="v2" xmlns:ns2="v3" xmlns:ns3="v31">
<Header></Header>
<Body>
<ns2:IndividualRequest>
<ns1:header>
<ns1:senderID></ns1:senderID>
<ns1:messageID>CustMaintV3-Indiv</ns1:messageID>
</ns1:header>
<ns2:IndividualCustomerInformation>
<ns3:CustUcn>6921876</ns3:CustUcn>
<ns3:CustCoid>0015</ns3:CustCoid>
</ns2:IndividualCustomerInformation>
<ns2:IndividualCustomerDemographics>
<ns2:CustName1>xxxx</ns2:CustName1>
<ns2:CustName2>xxx</ns2:CustName2>
</ns2:IndividualCustomerDemographics>
<ns2:IndividualCustomerPhysicalAddressInformation>
<ns3:AdrCity>CHE</ns3:AdrCity>
<ns3:AdrCountry>IN</ns3:AdrCountry>
</ns2:IndividualCustomerPhysicalAddressInformation>
<ns2:IndividualCustomerPostalAddressInformation>
<ns3:AdrCity>HYD</ns3:AdrCity>
</ns2:IndividualCustomerPostalAddressInformation>
<ns2:IndividualCustomerMarketingConsent>
<v:fnbMarketConsent>Y</v:fnbMarketConsent>
</ns2:IndividualCustomerMarketingConsent>
<ns2:CustomerCreditScoringInformation>
<ns2:DebtCouncilInd>N</ns2:DebtCouncilInd>
</ns2:CustomerCreditScoringInformation>
<ns2:IndividualCustomerRegulatoryInformation>
<ns3:SofCounter>999</ns3:SofCounter>
</ns2:IndividualCustomerRegulatoryInformation>
<ns2:CustomerContactInformation>
<ns2:EmailAddress>JAPAN@GMAIL.COM</ns2:EmailAddress>
</ns2:CustomerContactInformation>
</ns2:IndividualRequest>
</Body>
</Envelope>
please advise.